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!

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

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.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

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:

Edward-Icon-Set-Conditional-Formatt.xlsx

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:

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

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
Ramin, I like that but can you make the arrows green and red? :)

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.

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.

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

Get an unlimited membership to EE for less than $4 a week.

Unlimited question asking, solutions, articles and more.

Well done !

Thanks gentlemen!

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.

Thanks for that, Edward - much appreciated!

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:

Formula for Helper Column would be:

Open in new window

To determine which cell is greater, lower or equal.Hope this helps.