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" ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Excel 2007...
Conditional Formatting is on the HOME ribbon... You can combine conditions if it can be (logically done) If you comapre like this =M230 You can take care of 'Exempt' like this =AND(M230,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... "SunshineinFt.Myers" wrote: 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" ? |
Reply |
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 |