LUIS FREUND
asked on
Using Conditional formatting arrows to show cost is less than or greater than
I have this simple question I hope. On the attachment I have arrows to show cost is less than or greater than.
Here is what I'm looking. At C2 I wanted the arrow C3 to be red showing that B2 is less than A2 and green arrow when B3 is greater than C3. I want the arrows on column C. See example. Also I'm sure this can be filtered.
C--Users-lfreund-Downloads-COST-ARR.xlsx
Here is what I'm looking. At C2 I wanted the arrow C3 to be red showing that B2 is less than A2 and green arrow when B3 is greater than C3. I want the arrows on column C. See example. Also I'm sure this can be filtered.
C--Users-lfreund-Downloads-COST-ARR.xlsx
ASKER
not really to concerned with the values in column C. How would you apply this if I had a value in column A and column B is blank? I would prefer not to have an arrow there.
Hi Luis,
I have done it with a different setup by not using the conditional formatting inbuilt icon sets. See if that works for you.
C--Users-lfreund-Downloads-COST-ARR.xlsx
I have done it with a different setup by not using the conditional formatting inbuilt icon sets. See if that works for you.
C--Users-lfreund-Downloads-COST-ARR.xlsx
ASKER
LOOKS AWESOME. Can we make it work, for example column B is blank but there is a value in column A? Right now if I was to delete the number in column B the down arrow is visible. There will be times when column B may not have anumber
What if A = B?
ASKER
not likely.....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much!
You're welcome Luis!
29093576.xlsx