Excel 2007 : Conditional formatting-How to do it?

[hot_ice]

Hi Sir,
I need help to accomplish b/m conditional formatting...
In my sheet, I've highlighted weekdays in a cell range (c7:ag7). I want to fill all the cells which appear below Sunday header with a specific color. How to do it? Need a quick reply

[teylyn]

Hi,

the function =Weekday(date) returns a number from 1 (Sunday) to 7 (Saturda) (-- These are the formula defaults. There is a parameter return_type, too, to change the number/Weekday assignment). You can use this function in conditional formatting. Create a new rule with "Use a formula to determine ..." and set the formula to be

=WEEKDAY(C$7)=1

If you need more help with this, post a small data sample that illustrates your data layout.