Equal to, less than or more than "IF" formula with coloured outputs.

[Rhys Ashton]

Hi All

I wondered whether anybody could help me?

I currently have an "IF" formula on a spreadsheet that compares two cells and outputs an up arrow or down arrow (Webdings 5 & 6) depending on whether the value has increased or decreased.

I was wanting to know if it was possible to do something similar but have it so that it outputs an up arrow in green if the number has increased, a amber arrow pointing sideways if the number has stayed the same and a red arrow pointing down if the number has decreased (something like Webdings 4, 5 and 6).

Many thanks for your help.
Rhys

[Special-K]

Select the range to highlight

Conditional Formatting
New Rule
Use a formula to determine...

Youll need 3 formulas one for each colour.
Enter each formula where the value is true.
So if your standard formula is IF(A1>B1...
just enter =(A1>B1)
then select which colour you want

[Rhys Ashton]

Hi

My formula is =IF(D3>=D13,"5","6")

if I...

Conditional Formatting
New Rule
Use a formula to determine...

I insert the formula =(D3>D13) and this let me format it so that the cell turns green but obviously doesn't insert the arrow.

If I add the ,"5" to the end as I did for formula true in my initial formula (so =(D3>D13,"5") it says error.

Is there something I am missing?

Many thanks
Rhys

[Special-K]

Conditional formatting formats a cell, it doesnt change the value, just the look
so =(D3>D13) is correct to change the colour.

Keep your original formulas
IF(D3>=D13,5,6)

I'm assuming webdings 5 and 6 is the arrow up and down.
i dont know if there is a sideways arrow, youll have to look at webdings to find out and amend your formula if the value stays the same.

[Rhys Ashton]

Ahh ok thanks. I did try that and it didn't seem to work.

Deleted everything and done it again from scratch and it is working this time.

Thanks

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.