Conditional formatiing based on another cell

[Number_8]

Hi,

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

Thank

 

[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
(e-mail address removed)
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====

 

[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