I want to format a cell based on an adjacent cells value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like a cell automatically formatted in the same way a conditional
format works - but the format to be based on the value of an adjacent cell.

Any ideas as I cant work out how or if I can achieve this
 
Cumbo, Use Conditional Formatting, but change cell valve is to formula is
and use something like this, will change the cell if A1=25
=$A$1=25, so if you select B5 and put this in conditional formatting cell B5
will change when A1 = 25


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You must log in or register to reply here.

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

conditionally formatting cells based on other cells 1
Inherit formatting from adjacent cells 2
conditional formatting on formua with another cell 2
condionally formatting based on another cells formatting? 2
Conditional Formatting dependent on another cell 3
Conditional Formatting for adjacent cells 1
Auto Row Height with Wrapped Text in Merged Cells Problem 3
conditional formatting based on the value of another cell 8

Back
Top