Conditional formatiing based on another cell

[Number_8]

Hi,

How can I change the colour of a cell and a seperate query an entire row based on the value in a call. For example cell A1 has a number 200 in it. Cell B1 is blank. If "yes" is entered in to cell B1, I want cell A1 to change to be in bold and a grey box. Ihave tried conditional formatting but doesnt seem to work.

Thanks

[Daniel CHEN]

select A1, then conditional format -
Condition 1: formula is (Not value is ) =(B1="yes")
Format what you want.


===== * ===== * ===== * =====
Daniel CHEN

Spreadsheet/VBA Specialist
[email protected]
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====

"Number_8" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> How can I change the colour of a cell and a seperate query an entire
> row based on the value in a call. For example cell A1 has a number 200
> in it. Cell B1 is blank. If "yes" is entered in to cell B1, I want cell
> A1 to change to be in bold and a grey box. Ihave tried conditional
> formatting but doesnt seem to work.
>
> Thanks
>
>
> --
> Number_8
> ------------------------------------------------------------------------
> Number_8's Profile:
> http://www.excelforum.com/member.php...fo&userid=6590
> View this thread: http://www.excelforum.com/showthread...hreadid=375666
>

[Number_8]

Thanks for that. However it doesnt work. Not sure whether teh fact taht I am on a Mac has affected it? The formatting doesnt change at all.

Any other solutions?

[OverAC]

That's good advice!

You should change the value in the first combobox from 'Cell value is' to 'Formula is' and then enter ' = (B1 = "yes") then next box. That will help

Regards

OverAC