How conditional format line with date of today

  • Thread starter Thread starter dewsbury
  • Start date Start date
D

dewsbury

Hi,

tried setting conditional where cell = today().

However, today was converted to ="today()" and the format was no
applied.

The format does work if I hardcode the date. I.e. it work if I pu
=04/11/04 instead of =today().

However I need to use the today() function.

Any other suggestions?

Thanks
 
Select the cell to CF.

Format>CF> formula is: =cellref=TODAY()

where cellref is the cell you have selected.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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 Formating based on Date 5
Conditional Format help 5
Conditional Format Help 2
Highlight date nearest to TODAY() 1
Excel Macro to automatically go to the right of the last colored cell 0
conditional formatting date and blank cell 3
Conditional Format with dates 5
formula in conditional formatting with dates 3

Back
Top