ssblue
asked on
Excel Conditional formatting - icon sets
how do use the icon sets on a range of cells
I want to use the 3 arrows for each cell in range B7 - K17
each row should reference row 3
example:
B7 ref B3
C7 ref C3
B8 ref B3
C8 ref C3
B17 ref B3
See attachment
ConditionalTest.xlsx
I want to use the 3 arrows for each cell in range B7 - K17
each row should reference row 3
example:
B7 ref B3
C7 ref C3
B8 ref B3
C8 ref C3
B17 ref B3
See attachment
ConditionalTest.xlsx
ASKER
Not quite. I need the reference to change. Column B should reference B3 - Column C should reference C3 etc...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
Your welcome
Is this what you want ?
gowflow
ConditionalTest-V01.xlsx