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

Question

Previous Topic Next Topic

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

[Closed]

Report

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: 2779
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 29, 2021

- 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
Conditional format to highlight cell based on date ✓ - Forum - Excel
Conditional Formatting a single cell based on another range ✓ - Forum - Excel
Excel count conditional formatting color cells - Forum - Excel
Conditional formatting to change cell color ✓ - Forum - Excel
Excel copy conditional formatting color to another cell ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2014-10-14T11:04:25-0400

Answer 1 / 1

TrowaD

Posts: 2779
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 29, 2021

468
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

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

1 reply

Your reply

Subscribe To Our Newsletter!