Conditional formatting based on two cells (date and comment) [Solved/Closed]

Question

Conditional formatting based on two cells (date and comment) [Solved/Closed]

Report

jayelpe - Aug 4, 2016 at 11:18 AM
jayelpe - Aug 4, 2016 at 12:20 PM

Hi guys and dolls,

I am hoping one of you clever people might be able to help me...

I am trying to highlight a cell when 1. a date has passed and 2, the task has been marked as Outstanding.

I am playing in conditional formatting and can do each individually, but cannot work out how to make this happen together?

Also - and this is not essential - more of a learning point, can you choose or more than one cell to be formatted as a result?

Thanks for your help.

Lucie

Conditional formatting based on two cells (date and comment)
Conditional formatting based on another cell; apply to rows ✓ - Forum - Excel
Conditional Formatting based on two cell values ✓ - Forum - Excel
Conditional formatting based on another cell ✓ - Forum - Excel
Conditional formatting based on another cell ✓ - Forum - Excel
Excel conditional formatting based on another cell text ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-08-04T11:41:12-0400

Answer 1 / 1

TrowaD

Posts: 2675
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 5, 2020

448
Aug 4, 2016 at 11:41 AM

Hi Lucie,

Combine the 2 formulas using AND:
=AND(first formula , second formula)

For your second question, choose to manage your rules. The 3rd column of the overview shows the applied range.

Let me know if something is still unclear.

Best regards,
Trowa

Report

jayelpe
Aug 4, 2016 at 12:20 PM

thank you so veru much for your speedy response :)

Conditional formatting based on two cells (date and comment) [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!