| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I'm attempting shade cells using the conditional formatting option.
The conditions I am using are as follows... If cell X is greater than cell T then shade green. If cell X is less than cell T then shade red. If cell X is equal to cell T then shade blue. These conditions have been applied to a particular column. The issue is that if the cell has no value at all it shades red. I do not want this to happen as data has not yet been gathered for this cell. Any solutions or ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
Change the red condition to:
Formula is: =AND(isnumber(cellX),Cell_X<Cell_T) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "AL" wrote: I'm attempting shade cells using the conditional formatting option. The conditions I am using are as follows... If cell X is greater than cell T then shade green. If cell X is less than cell T then shade red. If cell X is equal to cell T then shade blue. These conditions have been applied to a particular column. The issue is that if the cell has no value at all it shades red. I do not want this to happen as data has not yet been gathered for this cell. Any solutions or ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
CF/ Formula Is: =AND(X2<"",X2<T2)
-- David Biddulph "AL" wrote in message ... I'm attempting shade cells using the conditional formatting option. The conditions I am using are as follows... If cell X is greater than cell T then shade green. If cell X is less than cell T then shade red. If cell X is equal to cell T then shade blue. These conditions have been applied to a particular column. The issue is that if the cell has no value at all it shades red. I do not want this to happen as data has not yet been gathered for this cell. Any solutions or ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
