Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Formulas
Hi.
I want to set up some conditional formatting (in Excel 2003). I want to turn certain cells either red (if any text appears) or green (if the cell appears blank). However, the cells have formulas in them to display information if it is available in other cells. I cannot, however, make the conditional formatting work - as I cannot use functions such as is/is not blank - as the cells still contain formulas - so whilst they are not displaying inforamtion there is still information in the cells which the conditional formatting is picking up. Does anyone know if there is a function that allows you to use conditional formatting based on what is displayed in a cell, rather than it formula contents - or is there another workaround?? Thanks. Liz. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting and Formulas
Liz,
Try a formula of =LEN(A2)=0 -- HTH Bob "BoRed79" wrote in message ... Hi. I want to set up some conditional formatting (in Excel 2003). I want to turn certain cells either red (if any text appears) or green (if the cell appears blank). However, the cells have formulas in them to display information if it is available in other cells. I cannot, however, make the conditional formatting work - as I cannot use functions such as is/is not blank - as the cells still contain formulas - so whilst they are not displaying inforamtion there is still information in the cells which the conditional formatting is picking up. Does anyone know if there is a function that allows you to use conditional formatting based on what is displayed in a cell, rather than it formula contents - or is there another workaround?? Thanks. Liz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas in conditional formatting | Excel Worksheet Functions | |||
Conditional formatting formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting and If/Then Formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) |