Formatting a cell using a logical function/test

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I would like to color code a cell after a logical function
such as an IF function has run. For example, if we have a
cell with a value between 90% and 100%, we would like to
color code the cell green. Any thoughts on how to do this
without manually changing the cell fill color to green?
Thanks.
 
Lori,

You will want to use conditional formatting. This can be
found on the Format menu at the top. Set your criteria and
the format you choose to use and then you can write your
If statement and it will format when that condition is met.

Rekoj
 
Back
Top