Excel Conditional Formatting - sum column and colour scale-CodePudding

I have an excel where I need to calculate the sum of duration in every week and highlight the cells in green whose sum is >20hrs and red if sum < 20hrs. All the values in column B and C are duration (2hrs, 4hrs and so on) and not time. According to my knowledge Conditional Formatting should work. Could someone please help!

Expected Output

Thanks:)

CodePudding user response：

In cells B1:C6, enter a pair of conditional formats by formula:

=B$7>TIMEVALUE("20:00")
=B$7<TIMEVALUE("20:00")

You'll probably want to change one of your comparisons to >= or <= to handle the case in which the times add up to exactly 20:00.

CodePudding user response：

Go To Format Condition Use Greater Then And Less Then

Greater Then enter value =20

Less Then value =20