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 January 16, 2023 - 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.

Conditional formatting-color a cell based on the value of anothe
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Conditional formatting if another cell contains - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Conditional formatting if two cells match ✓ - Excel Forum
Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

Condition formatting on changing cell color based on another cel

help me to add particular cells

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!