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

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

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

Let's say your doing this conditional formatting in cell K17. In
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 which
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 the
same cell.



andreashermle;731842 Wrote:

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

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=205130

http://www.thecodecage.com/forumz

Conditional formatting if condition of an if statement is trueand a string value is displayed
 

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

On 26 Maj, 17:55, andreashermle wrote:
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