Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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" ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |