Previous Topic Next Topic

Conditional Formatting Excel 2010 based on content in other cell

Closed
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
Related:

1 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response