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
Clear only the formatting from the selected cell (leaving the content) - Guide
If a cell has text then return value ✓ - Excel Forum
Notepad++ background color - Guide
Color coding of rj45 - Guide
Sound card color code - Guide

1 response

Answer 1 / 1

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

Highlight cell if another cell contains specific text

help me to add particular cells

Fill adjacent cell with number from text answer

How to use conditional format based on text?

Excel function question

Similar discussions

Subscribe To Our Newsletter!