Prev: Reading system log files
Next: Cosmetics
From: p45cal on 26 May 2010 17:23

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.




a
n
d
r
e
a
s
h
e
r
m
l
e
;
7
3
1
8
4
2

W
r
o
t
e
:


>
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/showthread.php?t=205130

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Reading system log files
Next: Cosmetics