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

Report
Posts
1
Registration date
Thursday May 23, 2013
Status
Member
Last seen
May 23, 2013
-
Posts
2735
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 29, 2021
-
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

1 reply

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

I tried this in Excel 2003 and found no issues.

Which version are you working with?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!