If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|