Conditional Format based on other cell's value

  • Thread starter Thread starter Stella
  • Start date Start date
S

Stella

How do I make the format of A1 conditional on the value of B1

TIA
Stella
 
Stella

Select the cell whos format you want to change, go to format, conditional
format and change condition one to "formula is" and put in your condition in
the box. Select your format and hit okay. For example if you want cell A1
to be orange if B1 is greater than 5, enter "formula is" and "=b1>5"

Dave
 
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

Excel functions 0
Conditional Format - using 3 different cells conditions together 4
Conditional Formatting 1
Conditional Formatting For A Cell Other Than The One With The Form 2
Conditional Formatting Driving Me Crazy 1
If function with format 1
Conditional Formatting 1
Conditional Formatting in Excel 2007 1

Back
Top