Conditional Formating Help Please!!

[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

 

[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

 

[sammy2x]

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

Thanks again,

Sam.

 

[Guest]

<> is the "does not equal" operator.

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

XL2002, WinXP-Pro