View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Conditional Format - If day = 24 or 25

In that case you would use this formula:

=OR(DAY(TODAY())=24,DAY(TODAY())=25)

Hope this helps.

Pete

On Jan 26, 1:27*am, mjones wrote:

Thanks for replying. *I need to clarify though.

I meant the actual day, like today() knows the actual date. *The date
is not in a cell.

Is this still possible?