condtional formatting

[adn4n]

Hi i just wanted to know how to condtional formula a date, basicall
people dont work on 25/12/** (** = whichever year) as it is Xmas day
therefore i would like to condtional format this cell.

Lets say the Date is in cell A:1, i went to:
1) Format
2) Condtional Formatting
3) then i am not sure if i should leave the drop down as 'Cell Value
or changed it to 'Formula'.

Also am not sure what to put into the formula bar, thats if it i
'formula' that has to be selected in the drop down at the conditiona
formatting dialogue box. Can anybody please help me..

regards

 

[Alan]

=IF(AND(DAY(A1)=25,MONTH(A1)=12),1,0)
ie If the day is 25 and the month is 12 then the condition is true so the
conditional format will apply,
Regards,

 

[Alan]

Sorry, use 'Formula'

=IF(AND(DAY(A1)=25,MONTH(A1)=12),1,0)
ie If the day is 25 and the month is 12 then the condition is true so the
conditional format will apply,
Regards,