condtional formatting

  • Thread starter Thread starter adn4n
  • Start date Start date
A

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
 
=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,
 
Sorry, use 'Formula'

Alan said:
=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,
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format text Excel 2003 2
Copy and Paste Conditional Formatting 3
Conditional Formatting Question 3
Conditional Format - Excel 2007 1
Cell referencing for condtional formatting 3
conditional formatting 8
Conditional formatting in 2007 3
Wildcard In Condtional Formatting. 3

Back
Top