Link to home
Start Free TrialLog in
Avatar of Edward Pamias
Edward PamiasFlag for United States of America

asked on

Excel conditional formatting.

All,

I need a conditional format formula that will look in cell B2 from C2 if the value is greater arrow up will appear in C2 if lower then arrow down will appear and I need to copy the formula across the row. So it will do the same for D2 and C2, E2 and D2..... etc....

Thank in advance!
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Edward,

Conditional Formatting with Icon Set rule, you cannot use Formula with cell reference as range. With the help of Helper Column we can create Icon Set. See below:
User generated imageFormula for Helper Column would be:
=SIGN(B2-C2)

Open in new window

To determine which cell is greater, lower or equal.
Hope this helps.
Edward-Icon-Set-Conditional-Formatt.xlsx
Avatar of Edward Pamias

ASKER

I need the arrows in the cell not in another column... please.
I am looking at this more closely, so let me clarify this a bit more. If B2 = 100 and C2 = 99, I need to have C2 with the value 99 and a down arrow and the same for all the following cells. If each cell is higher or lower I need the value and the arrow in the same cell up arrow for higher value, down arrow for lower value.
Hi Edward,

As I said, we cannot refer to range, you can have Icon Set on the Cell, but you need to do Conditional Formatting to each cell like below:
User generated imageEdward-Icon-Set-Conditional-Formatt.xlsx
SOLUTION
Avatar of Ramin
Ramin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ramin, I like that but can you make the arrows green and red? :)
Avatar of Ramin
Ramin

Okay, but give me some more time.
OK.. so the only problem is I have one row of values I do not want to have another row with values and arrows. I want them all on the same row.
Shums will continue from here. I just wanted to give him an idea. He is really perfect in excel.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well done !
Thanks gentlemen!
You're Welcome Edward! Glad eventually it worked for you :)
Thanks for that, Edward - much appreciated!