| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditonal Format with a date format
I have a page with colum A1:A365 date formatted I would like all stat days to
turn red Conditional format I am trying to use is, =OR(A1:A365=DECEMBER 25, 2004, A1:A365=JANUARY 1, 2005) ect ect I If I type December 25 2004 in column any cell in column A without a date format, it works. As soon as use a date format in column A1:A365 the conditional format does not work. Can anyone help?? Thank you Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
