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


--
sammy2x
------------------------------------------------------------------------
sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674
View this thread: http://www.excelforum.com/showthread...hreadid=496653

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=496653

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

Thanks again,

Sam.


--
sammy2x
------------------------------------------------------------------------
sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674
View this thread: http://www.excelforum.com/showthread...hreadid=496653

<> is the "does not equal" operator.

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

XL2002, WinXP-Pro


"sammy2x" wrote:

>
> Thanks Ron, That's spot on. Sorry for future reference what does the <>
> do?
>
> Thanks again,
>
> Sam.
>
>
> --
> sammy2x
> ------------------------------------------------------------------------
> sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674
> View this thread: http://www.excelforum.com/showthread...hreadid=496653
>
>