| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - Reference to multiple column
I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3. For example, If G40 < 3 but E40 <=3 then G40 won't be highlighted If G40 < 3 but E40 3 then G40 will be highlighted If G40 3 then no action will be taken I'm using Excel 2007. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference another cell in conditional formatting | Excel Worksheet Functions | |||
| cell reference changes and conditional formatting | Excel Worksheet Functions | |||
| Multiple Column Conditional Formatting | New Users to Excel | |||
| Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
| Conditional Formatting, reference another column | Excel Worksheet Functions | |||
Threaded Mode
