| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by results in two different cells
I want my background to highlight red if the cell in column D AND the cell in
column L are both less than zero. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting by results in two different cells
One way:
Assume the cell to have the CF applied is in Row 2: CF: Formula is =AND($D2<0,$L2<0)) Format1: <pattern/<red In article , Supe wrote: I want my background to highlight red if the cell in column D AND the cell in column L are both less than zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Conditional Formatting Results | Excel Discussion (Misc queries) | |||
| Formatting results of formulas within merged cells | Excel Discussion (Misc queries) | |||
| CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL | Excel Worksheet Functions | |||
| Results of conditional formatting not what desired. How do I corr | Excel Worksheet Functions | |||
| Conditional formatting producing inconsistant results? | Excel Discussion (Misc queries) | |||
Linear Mode
