Excel, Conditional formatting rows based on time values

0
votes

I cant figure out a formula for conditional formatting to highlight a row (not just a cell) based on a cells value being less then a specific time.

The less then time is "18:00"

I have 4 columns and 50 rows and the time data is in column D2 (D2 to D51)

1
excelfunctionconditionalconditional-formatting

1 Answers

3
votes

Apply conditional formatting to the range A2:D51 and use the following formula as a condition:
=$D2<TIME(18,0,0)