Conditional formatting if condition of an if statement is true and astring value is displayed

[andreashermle]

Dear Experts:

I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.

I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.

How can this be achieved using excel conditional formating
functionality ?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

 

[p45cal]

Let's say your doing this conditional formatting in cell K17. I
conditional formatting (xl2003) choose the FormulaIs: option and enter:
=$K$17<>""
choose your formatting and OK.

In xl2007, choose NewRule..., then 'Use a formula to determine whic
cells to format' and in the 'Format values where this formula is true
field, use the formula given above, set your format and OK.
Make sure there are no other conditional formats interfering in th
same cell.

 

[Per Jessen]

Hi

Select the cell, in my example I will use A1, goto conditional
formatting > Condition1: Formula is > enter this formula:

=A1<>""

Select the desired formatting.

Hopes this helps.
....
Per