Cell Color

  • Thread starter Thread starter apasuper8
  • Start date Start date
A

apasuper8

I have developed a spreadsheet that is keeping track of percentages i
Column B (about 32 cells). What I would like to do is once any one o
the cells gets to a value of 100% I would like to automatically chang
the cell color for that cell to lets say blue. Does anyone know where
can find out how to do this. Or have any suggestions. Thanks!

APASuper
 
You can use Conditional Formatting, and when the value
is greater than or equal to 100 in your case then set the cell value t
blue. If you want to use conditional formatting for the entire column
you can select entire column and use the "If formula is" option an
enter something like =If($C32>100)
and then set the format to a blue background
 
Back
Top