Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using icon sets with relative references
I am using Excel 2007 in the Vista OS.
I am trying to use conditional formatting with an icon set in a column but Excel will not allow relative references. Example: A1=10 min B1=20 max C1=30 oh D1=a formula { =IF(C1=0,B1,(B1-C1)) } The condtional formatting of D1 would be: if the value showing in D1 is B1 the cell would show a red 'X', if the value showing in D1 is <A1 the cell would show a green 'check mark', and if the value showing in D1 is between the values in A1 and B1 it would show a yellow 'exclamation point'. I can get the D1 to do this but when I try to copy the formatting down, cells below (D2:D12) all show an absolute reference to the cells in row 1. Is there a way to overcome this absolute referencing in Excel 2007? I have tried to delete the absolute in the formula itself in the conditional formatting dialog box but Excel returns an error and will not allow it. My apologies if this question is not as clear as you need it to be. This problem has me very muddled at this time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with Icon sets | Excel Discussion (Misc queries) | |||
if, then, else with Excel 2007 icon sets | Excel Discussion (Misc queries) | |||
Referencing Icon Sets | Excel Worksheet Functions | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Additional Icon Sets | Excel Discussion (Misc queries) |