Conditional Formatting

  • Thread starter Thread starter SunshineinFt.Myers
  • Start date Start date
S

SunshineinFt.Myers

My co-worker and I want to know how to do this in the 07 version. Cell M23
has an employee overtime value. Say anything > 0 we want it to highlight.
However, we do have the word "exempt" in some of the employees cells in
Column M and we don't want them to change color. Also, we we have a regular
employee hours column in say N23. We want it to highlight if it's between 1
and less than 80. Do we have to do each column seperate? And, where would we
go to in the new version? And, how do we not include those cells that say the
word "exempt" ?
 
Excel 2007...
Conditional Formatting is on the HOME ribbon...
You can combine conditions if it can be (logically done)

If you comapre like this
=M23>0
You can take care of 'Exempt' like this
=AND(M23>0,M23<>"Exempt")

Conditions are evaluated relative to the cell it is defined for...
You can refer to other cells...
You can have absolute references if you want to check the value in a
particular cell for all cells in the range...
 
Back
Top