Conditional formatting-color a cell based on the value of anothe

[Closed]
Report
Posts
1
Registration date
Friday October 10, 2014
Status
Member
Last seen
October 10, 2014
-
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
-
Hello,
I have 2 columns of cells: R1-R100 & S1-S100. The cells in column R are the sum of cells L2:Q2, etc are is labeled "Expected Time to Process Batch". Column S is based on the start & end time of when the employee started and ended their batch. These times are entered in cells D1 & E1.
What I need to do is color code the cells in column S to "Red" (for not met) or "Green" (for met) based on whether the employee didn't meet or did meet the expected time in Column R.
Can anyone help me? Please.

1 reply

Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
Hi Wharrington,

Use conditional formatting, choose to use a formula:
=S1="Not met" -change format to red.
=S1="Met" -change format to green.

Apply this to the full range S1:S100.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!