Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It seems to me that you have used CF only with the Cell Value Is
option. There is a Formula Is choice where you enter a formula that evaluates to true/false. This feature is the one of choice when we want to base formatting on the values of other cells. In there you can use the formulas suggested by Elkar. HTH Kostis Vezerides |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting - Can I select a select with Conditional Formatting? | Excel Worksheet Functions | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional formatting on a PivotTable? | Charts and Charting in Excel |