T.Valko!!!
Finally I've managed to get it working!!!!
Many many thanks for sticking with me on this.
thanks for your step by step instructions,,, I still can't tell you for sure what I done wrong,, most of this I did do,, but I just must have mucked up somewhere in you process you described...Again, many thanks.
(Even with your step by step Instructions,,I still got it wrong several times believe it or not!!)
,,, due to school boy errors.
IE.. I was using your cell formula A3,, when I went to Conditional Formatting,,When mine was C2....,, getting tired (that's my excuse & I'm sticking to it!)
I also was trying to add the day in front,,,
So I did it all again with adding ddd in front of the other conditional formatting.
Here;s a screenshot T.Valko
[/code]
Again, many thanks...
I just need to now go through the same process to condition my other sheets.
Actually,, maybe I can do it on the same line in the conditional formatting???
What I mean is,, I conditioned your formulas then applied then to =$C$2
This is for a sheet called ToDo-FULL
I didn't know this,, but if I'm on another sheet,, 1 called TODO-LITE, & I go to conditional formatting,, but from the drop down choose the sheet TODO-FULL,, I've just noticed it lists all the conditional formats for that sheet.
Here's the interesting bit.
It shows the formulas now as;
='ToDo-FULL'!$C$2
So,, my thinking is,,, rather than apply the 4 same rules to the TODO-LITE sheet via your original method,,,
can I not just go back into the original conditional formatting & change the "Applied To" so the rule applies to both sheets???,, so cell C2 for both sheets???????
I'm not sure how it would look like,, but maybe something like;
I choose under Conditional Formatting Rules Manager
It shows, "Show Formatting Rules for current selection" (IE Cell C2)
I've inserted ;
=$C$2
I change this to maybe something like;
='ToDo-FULL'!$C$2,&,='ToDo-LITE'!$C$2
????????Maybe I can't do this? Maybe I've written it wrong?
It's just an idea T.Valko
Then I don't have to start 4 new formulas that are the same,, I just change the applied to so the formula I've just created applies to 2 sheets not 1
Is this possible T. Valko??
Again,,, really appreciate your help on this.
I just couldn't get it.
As a note,, I was thinking of still maybe adding a small bit of text in front of the =(TODAY())
That's in Cell C2. IE,,,,,,,,,, "Today Is:-"
Again,, maybe now with your new custom formatting it's not possible?
As a note,, I've tried;
Code:
Today Is:-(TODAY())
=Today Is:-(TODAY())
="Today Is:-"(TODAY())
="&TEXTToday Is:-"(TODAY())
="Today Is:-",(TODAY())
="Today Is:-" (TODAY())
=Today Is:-(TODAY(),
===================
None worked,, just a thought,,tried to wing it again
I need a cup of tea.
I'll say it again,,
many thanks for this T.Valko.
The spreadsheet is starting to really look sexy now,, well,, maybe not sexy,, but hey,,it's getting there.
All the best
A very Grateful
John Caines
