Conditional Formatting based on another cells Conditional Formatting

Hi

For the attached sheet, I'm trying to create a system that marks todays date in cell O4 with green in the table, and any date before that date with red. But I also want the cell to the right of the dates in the table to be marked with the same color as the ones in conditional formatting.

If possible, I need it to be done without VBA.

check attach file

Originally Posted by tranhieu04

check attach file

It is the empty cells to the right of the dates that I need to follow the same conditional formatting. Eg. if date is August 22nd, 22 is marked green along with cell E12 to the right of 22 in the table. Same goes for dates before todays date, but in red.

Just to clarify, this is what it is supposed to look like

Attachment 638277

hi,

I'm not good at Eng, maybe wrong.
i make again with 2 condition fomatting. Check file to more detail

Originally Posted by tranhieu04

hi,

I'm not good at Eng, maybe wrong.
i make again with 2 condition fomatting. Check file to more detail

Works perfectly - Just what I needed :-) Thank you!