Conditional Formatting range of date cells based on another cell

Solved/Closed

cleaverr Posts 3 Registration date Monday December 12, 2016 Status Member Last seen December 13, 2016 - Dec 12, 2016 at 03:00 PM
cleaverr - Jan 5, 2017 at 06:18 AM

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

Based on the values in cells b77:b81, what function can automatically return the value in cell c77
Based on the values in cells b77 b81 what function can automatically return the value in cell c77 - Best answers
Based on the values in cells b77 b81 what function can automatically return the value - Best answers
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Based on the values in cells b77 b81 ✓ - Excel Forum
Based on the values in cells b77 b81 c77 - Excel Forum
Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
If a cell has text then return value ✓ - Excel Forum

2 responses

Answer 1 / 2

Blocked Profile
Dec 12, 2016 at 05:24 PM

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!

cleaverr Posts 3 Registration date Monday December 12, 2016 Status Member Last seen December 13, 2016
Dec 13, 2016 at 06:22 AM

Sorry - please could you provide me with some more details (exact instructions) if possible.
many thanks

cleaverr Posts 3 Registration date Monday December 12, 2016 Status Member Last seen December 13, 2016
Dec 13, 2016 at 06:50 AM

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.

Answer 2 / 2

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 19, 2016 at 11:59 AM

Hi Rob,

May this pic guide you to your solution:

Best regards,
Trowa

Blocked Profile
Dec 19, 2016 at 04:40 PM

@TrowaD - Always quality from you! Thanks!

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 20, 2016 at 10:46 AM

Thanks, appreciate it!

cleaverr
Jan 5, 2017 at 06:18 AM

Sorry for the delay in replying - I have been away.
Many thanks for your help - just what I was after.

Similar discussions

Highlight cell if another cell contains any text

Conditional formatting with multiple rules and blank text cells

Condition formatting on changing cell color based on another cel

Conditional format based on another cell containing text

Conditional Formatting: Merged cell color

conditional formatting of a cell if another cell is blank

Similar discussions

Subscribe To Our Newsletter!