Conditional formatiing based on another cell

  • Thread starter Thread starter Number_8
  • Start date Start date
N

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
 
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"
===== * ===== * ===== * =====
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
2 conditions using conditional formatting 3
Changing Cell Background Color based on data from another cell 2
conditional formating not functioning in cell with formula? 4
Validate entry based on another cell value 6
Conditional Format Range of Cells 3
Conditional Formating based on Data Validation 3
How to set color for text based on conditions? 2

Back
Top