| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating multiple cells in 1 row based on a list of d
Hi,
I need to highlight various cells in 1 row based on a list of dates in a separate column. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formating multiple cells in 1 row based on a list of d
Look in help for conditional formatting or post a more concrete example
-- Regards, Peo Sjoblom "Clinton" wrote in message ... Hi, I need to highlight various cells in 1 row based on a list of dates in a separate column. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formating multiple cells in 1 row based on a list of d
In CF you'll need the "Formula Is", rather than "Cell Value Is" option.
If the formula evaluates to TRUE, rather than FALSE, then the CF will be applied. Don't forget to start your formula with an = sign, and be careful about whether you want absolute or relative addressing. -- David Biddulph "Clinton" wrote in message ... Hi, I need to highlight various cells in 1 row based on a list of dates in a separate column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating based on multiple comparisons | Excel Worksheet Functions | |||
| Conditional Formating based on many cells | Excel Discussion (Misc queries) | |||
| Conditional formating based on other cells | Excel Worksheet Functions | |||
| Conditional Formating based on multiple criteria | Excel Discussion (Misc queries) | |||
| list two columnar values based on conditional formating (text color) | Excel Worksheet Functions | |||
Linear Mode
