Menu
Ask a question Report

Conditional Formatting range of date cells based on another cell [Solved/Closed]

Posts
3
Registration date
Monday December 12, 2016
Status
Member
Last seen
December 13, 2016
 - - Latest reply:  cleaverr - Jan 5, 2017 at 06:18 AM
Excel Ask a question Report
Hi There,

There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be able to help.

I am trying to CF a row of cells (D2:K2). These all have different dates in them. The formatting is to be based on a date in another cell (B2) - so green if before this date and red if after this date. I will then be doing the same for rows below this (D3:K3 based on B3 etc.). The dates in Column B are all different as well.

Your guidance would be most welcome!

rgds

Rob
See more 

2 replies

Report
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1571
0
Thank you
Just compare the value in the two cells, and format it based on the condition. What if the cell contain "hello"? Would you be able to turn the cell red? Use the same type of formula to compare the values! Post back if you still have hardships!
Report
cleaverr
Posts
3
Registration date
Monday December 12, 2016
Status
Member
Last seen
December 13, 2016
 -
Sorry - please could you provide me with some more details (exact instructions) if possible.
many thanks
Report
cleaverr
Posts
3
Registration date
Monday December 12, 2016
Status
Member
Last seen
December 13, 2016
 -
So I am currently typing:

"IF(DATEVALUE,$D$2:$O$2<DATEVALUE,B2)" and formatting this for green.
and the same formula with > to be red.

but it is not working.
Report
Posts
2570
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2019
 379
0
Thank you
Hi Rob,

May this pic guide you to your solution:


Best regards,
Trowa
Report
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1571 -
@TrowaD - Always quality from you! Thanks!
Report
TrowaD
Posts
2570
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2019
 379 -
Thanks, appreciate it!
Report
-
Sorry for the delay in replying - I have been away.
Many thanks for your help - just what I was after.
Ask a question