order of conditional formats

[Emjaye]

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

 

[fairwinds]

Hi,

Change your last formula to:

=AND(WEEKDAY($A10,2)>5,ISNUMBER($A10),$A10=TODAY())

and use that as first CF.

The other ones you can keep as is and use as CF 2 and 3

 

[Sue Gould]

Hi, my connection died before Igot to reply to this, and I see you had a reply in the mean-time. However, I am curious. I guess I just didn't understand your question properly, because it seemed more simple to me.

As I understand it, you have a fixed list of dates, therefore, you know which ones are weekdays, so you can simply 'pattern' them yellow.

Then stick =today() in any cell (say A1) and do CF as =$A$1, format red bold etc.

This appears too simple beside what you were both doing, so, what did I miss? (It all helps my learning) Thanks, Sue

 

[Emjaye]

Thanks Fair Winds, got that to work fine.

Sue, yes you're right however the planner can be changed for each year by the user by enter the required year in a seperate cell, then the weekends calculate for that year, so fixed shading wouldn't work in this case I'm afraid

Mike

 

[Sue Gould]

OK - that makes sense now, thanks.