Hi team,
I'm following the 'Interactive Project Management Dashboard' tutorial via https://www.youtube.com/watch?v=5qtSioTE2wY
When doing the conditional formatting section it returns with:
There's a problem with this formula. Not trying to type a formula? When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula. you type: =1=1, cell shows : 2 To get around this, type an apostrophe (') first: you type: '=1=1, cell shows: =1+1
I've tried region settings, 'Use System Separators', changing separators from a comma to a semi-colon and formatting cells to general rather than number etc.
I can't seem to find any resolve for this. Any ideas please? Many thanks for your help.
I'm using Windows 10 Enterprise.
Hello Clio,
You can find more guidelines to the techniques used here.
https://www.myonlinetraininghub.com/excel-project-management-dashboard
What is the syntax of your formula? Is it the exact same as in Mynda’s downloadable workbook and which one are you having trouble with?
Br,
Anders
Hi Anders,
I've had a look at the link you provided and still haven't been able to resolve the issue.
The formulas used are those of Mynda's and the issue is the same with all the conditional formatting formulas in the video.
The only difference is that I was unable to use the SEQUENCE formula and had to use the alternative formula provided by Mynda in the video comments (below):
"For those who don't have the SEQUENCE function, you can use two formulas instead: Cell K5: =MIN( start date column ) + output of form control Cell L5: =K5+1 Copy L5 across columns as far as required."
However, I'm not sure if using this alternative formula would prevent me from conditional formatting?
(I've added a snippet of my screen and the same of the video of Mynda's formula used. The only difference is my data is in cell L$5 rather than K$5).
Any help/thoughts would be much appreciated.
Clio
Hi Clio,
Nothing attached. Be sure to click the 'Start Upload' button after selecting your attachment.
Mynda
Thanks Mynda (still learning :))
Hello,
It looks to me that you have asterisks (*) instead of quotation marks (”) in the end of your formula.
Try copy this formula: =AND(WEEKDAY(L$5,2)>5,$B6<>"")
Br,
Anders
Hi Anders 🙂
Many thanks for your help! I couldn't quite see the quotation mark symbol from the video. Your solution has fixed the problem.
Once again many thanks for your help, much appreciated.
Clio
