Color Cell based on value

  • Thread starter Thread starter xxnonexnonexx
  • Start date Start date
X

xxnonexnonexx

Is there simple way to color a cell based on its value be it calculated or
entered?

Like:

Cell Yellow if between 1-17
Cell Green if + - 6 of 100
Cell Red if => 117

The idea is to highlight certain situations that need attention.

I'd prefer NOT to use macros or VBA but a formula that is entered into the range
of cells, if possible.

Any thing thats not in the criteria above would be left unchanged.

Thanks in advance.
 
Back
Top