Conditional Formating Help Please!!

S

sammy2x

Hi,

I'm sure this fairly simple but I seem to be struggling!

Lets say B1 contains a formula which will return either a value (Text)
or an empty cell (""). if the returned value is not an empty cell ("")
I want to hilight C1 yellow, if B1 is blank ("") C1 will remain
un-hilighted.

This also needs to work for B2,B3.....etc.

Cheers guys
 
R

Ron Coderre

Try this:

Select from C1 down as far as you need.

With C1 as the active cell:
Format>Conditional Formatting
Formula is: =AND(ISTEXT(C1),C1<>"")
Click the [Format...] button and set your format
Click [OK] twice

Test the cells
(If the "Formula is" needs tweaking, let us know)

Does that help?

Regards,
Ron
 
S

sammy2x

Thanks Ron, That's spot on. Sorry for future reference what does the <>
do?

Thanks again,

Sam.
 
R

Ron Coderre

<> is the "does not equal" operator.

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top