Conditional Formating Help Please!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sammy2x - 29 Dec 2005 15:05 GMT

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

Signature

sammy2x

Reply to this Message

Ron Coderre - 29 Dec 2005 15:38 GMT

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

Signature

Ron Coderre

Reply to this Message

sammy2x - 29 Dec 2005 16:20 GMT

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

Thanks again,

Sam.

Signature

sammy2x

Reply to this Message

Ron Coderre - 29 Dec 2005 16:42 GMT

<> is the "does not equal" operator.

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

XL2002, WinXP-Pro

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

Reply to this Message