Avatar of Edward Pamias
Edward Pamias
Flag 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!
Microsoft OfficeMicrosoft ExcelSpreadsheets

Avatar of undefined
Last Comment
Ramin

8/22/2022 - Mon
Shums Faruk

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:
Icon SetFormula 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
Edward Pamias

ASKER
I need the arrows in the cell not in another column... please.
Edward Pamias

ASKER
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Shums Faruk

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:
Icon SetEdward-Icon-Set-Conditional-Formatt.xlsx
SOLUTION
Ramin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Edward Pamias

ASKER
Ramin, I like that but can you make the arrows green and red? :)
Ramin

Okay, but give me some more time.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Shums Faruk

Edward Pamias

ASKER
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.
Ramin

Shums will continue from here. I just wanted to give him an idea. He is really perfect in excel.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Ramin

Well done !
Edward Pamias

ASKER
Thanks gentlemen!
Shums Faruk

You're Welcome Edward! Glad eventually it worked for you :)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Ramin

Thanks for that, Edward - much appreciated!