Conditional Formatting date issues

[Closed]
Report
Posts
1
Registration date
Friday January 10, 2014
Status
Member
Last seen
January 10, 2014
-
 Blocked Profile -
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

1 reply


Have a go at using:
=today()-numberofdays

Where numberofdays is your variable.

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