Previous Topic Next Topic

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

Closed
wharrington
Posts
1
Registration date
Friday October 10, 2014
Status
Member
Last seen
October 10, 2014
 - Oct 10, 2014 at 05:13 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 - Oct 14, 2014 at 11:04 AM
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

Answer 1 / 1
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
 510
Oct 14, 2014 at 11:04 AM
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
0