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

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
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
Clear only the formatting from the selected cell (leaving the content) - Guide
Excel formula to change cell color without conditional formatting - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum
How to change account based in instagram - Instagram Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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?

Highlight cell if another cell contains specific text

help me to add particular cells

Excel - IF function with multiple words

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!