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 December 27, 2022 - 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
Microsoft office 2010 free download - Download - Office suites
Need for speed: most wanted 2005 downloadable content - Download - Racing
Pdf and xps add in 2010 - Download - Other
Excel date format dd.mm.yyyy - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

help me to add particular cells

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!