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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Pille,

I tried this in Excel 2003 and found no issues.

Which version are you working with?

Best regards,
Trowa