| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - Comparative Versus Other Cells
I have a spreadsheet with numbers listed in columns D, F, H & J. I would
like to include conditional formatting so that if D is greater than F, H & J, it highlights in Green but if D is less than F, H & J, it highlights in Red. I tried using formula =If((D2F2),(D2H2),(D2J2) as one condition with the opposite as an additional condition but it highlights the column if it is greater than any of the other three. I need it to highlight only if it is greater or less than ALL 3. Any suggestions??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| conditional formatting of cells | Excel Worksheet Functions | |||
| Selected cells: item count versus summation | Excel Discussion (Misc queries) | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
| Paste link versus allowing two cells equal each other? | Excel Discussion (Misc queries) | |||
Threaded Mode
