Conditional Formatting date issues [Closed]

bananaman01 1 Posts Friday January 10, 2014Registration date January 10, 2014 Last seen - Jan 10, 2014 at 06:06 AM - Latest reply: ac3mark 8829 Posts Monday June 3, 2013Registration dateModeratorStatus February 22, 2018 Last seen
- Jan 10, 2014 at 04:44 PM
Hello, Please help

Conditional formatting will not work on columns displaying dd/mm/yyyy hh:mm:ss, (formatting highlights colour if todays date.)

This will work on the column with out the time (todays date ie 10/01/2014 00:00 but not on 10/01/2014 13:00)

Ive tried copying to a new column and removing and formatting to Date DD/MM/YYYY - but still doesnt high light the row.

(formatting rule - Use a formula to detemine which cells to format =$W4=TODAY(), colour selected)

What Im I doing wrong? Excel 2010

Thank you in advance
See more 

1 reply

ac3mark 8829 Posts Monday June 3, 2013Registration dateModeratorStatus February 22, 2018 Last seen - Jan 10, 2014 at 04:44 PM
0
Helpful
Have a go at using:
=today()-numberofdays

Where numberofdays is your variable.

Look at:
http://ccm.net/forum/affich-735278-conditional-formatting#p735361