Log In
Register
Home
October 6, 2020
Offline
Hi team,
I'm following the 'Interactive Project Management Dashboard' tutorial via
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.
October 6, 2020
Offline
I'm using Windows 10 Enterprise.
VIP
Trusted Members
December 7, 2016
Offline
Hello Clio,
You can find more guidelines to the techniques used here.
https://www.myonlinetraininghu.....-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
October 6, 2020
Offline
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
July 16, 2010
Offline
Hi Clio,
Nothing attached. Be sure to click the 'Start Upload' button after selecting your attachment.
Mynda
October 6, 2020
Offline
Thanks Mynda (still learning :))
VIP
Trusted Members
December 7, 2016
Offline
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
The following users say thank you to Anders Sehlstedt for this useful post:
Mynda TreacyOctober 6, 2020
Offline
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
1 Guest(s)
