I'd appreciate some help here please, in a planner style spreadsheet I have a column of dates from 1 Jan to 31 Dec. Using CF I need to make the weekend dates cell colour or to make the current day font colour or both if the current day is a Saturday or Sunday
The problem is that one CF seems to be cancelling out the others, it doesn't matter which order I enter them
entered as formula...
CF1 is =today()
(format = font bold & red)
CF2 is =AND(WEEKDAY($A10,2)>5,ISNUMBER($A10))
(format = pattern pastel yellow)
CF3 is =AND(AND(WEEKDAY($A10,2)>5,ISNUMBER($A10)),TODAY())
(format = font bold & red, pattern pastel yellow)
(I'm checking whether it works by adjusting the system dates)
thank you
The problem is that one CF seems to be cancelling out the others, it doesn't matter which order I enter them
entered as formula...
CF1 is =today()
(format = font bold & red)
CF2 is =AND(WEEKDAY($A10,2)>5,ISNUMBER($A10))
(format = pattern pastel yellow)
CF3 is =AND(AND(WEEKDAY($A10,2)>5,ISNUMBER($A10)),TODAY())
(format = font bold & red, pattern pastel yellow)
(I'm checking whether it works by adjusting the system dates)
thank you