Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting - problem with text cell value from formula
I wish to apply conditional formatting with three conditions based on the
cell value, resulting in three different shading colors. The cells have formulae with if statements that return "n/a" if one of the referenced cells contain "n/a" or are blank. this results in the conditional formatting applying the color for the condition 0 when the cell value is "n/a" - i want it to leave these alone (i.e. no color) please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting - problem with text cell value from formula
I think you should see this:
http://www.contextures.com/xlCondFormat03.html =ISNA(A1) Regards, Ryan--- -- RyGuy "PBcorn" wrote: I wish to apply conditional formatting with three conditions based on the cell value, resulting in three different shading colors. The cells have formulae with if statements that return "n/a" if one of the referenced cells contain "n/a" or are blank. this results in the conditional formatting applying the color for the condition 0 when the cell value is "n/a" - i want it to leave these alone (i.e. no color) please help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting - problem with text cell value - solved
Problem solved - here is the solution:
cond. 1: formula is =IF(ISBLANK(H9),"",IF(H9<-5%,H9,"")) cond. 2: formula is =IF(ISBLANK(H9),"",AND(H9=-5%,H9<=0%)) cond 3: formula is: =IF(ISBLANK(H9),"",IF(H90%,H9,"")) this ignores all cells with text values and all blank cells. "ryguy7272" wrote: I think you should see this: http://www.contextures.com/xlCondFormat03.html =ISNA(A1) Regards, Ryan--- -- RyGuy "PBcorn" wrote: I wish to apply conditional formatting with three conditions based on the cell value, resulting in three different shading colors. The cells have formulae with if statements that return "n/a" if one of the referenced cells contain "n/a" or are blank. this results in the conditional formatting applying the color for the condition 0 when the cell value is "n/a" - i want it to leave these alone (i.e. no color) please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Referencing problem when copying conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) |