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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 14, 2014 at 11:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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.
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.
Related:
- Conditional formatting-color a cell based on the value of anothe
- Notepad++ background color - Guide
- Sound card color code - Guide
- If a cell has text then return value ✓ - Excel Forum
- Color 65535 - Guide
- Rj45 color code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 14, 2014 at 11:04 AM
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
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
