Date Formula and Conditional Formatting

[compd1]

Hi All,

Hoping someone could assist. Basically I am after a conditional format which will highlight a range of columns based on the date entered into a cell. I have attached a manual file which I have created to show the desired outcome. Any assistance will be very much appreciated.

Thanks,

Compd1.

[benishiryo]

hi compd1, select the range you want to apply to (i.e. C2:U5)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$B2>=C$1

format desired colour

[compd1]

Awesome!!. Thank you.