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" ?
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" ?