Previous Topic Next Topic

Conditional Formatting date issues

Closed
bananaman01 Posts 1 Registration date Friday January 10, 2014 Status Member Last seen January 10, 2014 - Jan 10, 2014 at 06:06 AM
 Blocked Profile - 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

1 response

Answer 1 / 1
Blocked Profile
Jan 10, 2014 at 04:44 PM
Have a go at using:
=today()-numberofdays

Where numberofdays is your variable.

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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses