Change Colour

  • Thread starter Thread starter Liz Smart
  • Start date Start date
L

Liz Smart

Is it possible to write a formula which will change the
background colour of a cell in a number is over a certain
amount?

If if(A1>3,change background colour of B1 to red)

Hope you can help

Thanks

Liz
 
Liz,

You can use the Conditional Formatting tool on the Format menu to
do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top