Conditional Formatting Excel 2010 based on content in other cell [Closed]

Question

Conditional Formatting Excel 2010 based on content in other cell [Closed]

Report

Pille

Posts: 1
Registration date: Thursday May 23, 2013
Status: Member
Last seen: May 23, 2013

- May 23, 2013 at 06:05 AM
TrowaD

Posts: 2735
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 29, 2021

- May 27, 2013 at 11:02 AM

Hello,

I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula?

In cell U5 I have the following formula:
=IF(T5<>"","CLOSED",IF(M5<>"","OUTSTANDING INVOICE",""))

I would like to color the cells P-T5 IF formula outcome in U5 displays CLOSED; otherwise I would like to leave blank.

I tried different methods, but they all seem to color as maybe the word CLOSED is included in the formula in U5.

Any ideas to solve this?

Thanks in advance

Conditional Formatting Excel 2010 based on content in other cell
Conditional formating is applied based on date in two cells ✓ - Forum - Excel
Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
VBA Conditional Formatting Excel 03 ✓ - Forum - Excel
4 color scale conditional formatting excel ✓ - Forum - Excel
Excel - Formula based on the color of cell - How-To - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2013-05-27T11:02:20-0400

Answer 1 / 1

TrowaD

Posts: 2735
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 29, 2021

460
May 27, 2013 at 11:02 AM

Hi Pille,

I tried this in Excel 2003 and found no issues.

Which version are you working with?

Best regards,
Trowa

Conditional Formatting Excel 2010 based on content in other cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!