Customise Icon Sets

[HuskyJones]

Hey folks
Are you able to customise or create your own icon sets in Excel 2013?

Patients not assessed at baseline = 15
Patients not assessed at post intervention = 5

Need the 5 patients to have a green down arrow as in this case it is better.

I've googled and searched the forum but can't see an answer - help oh experts please

 

[My Aswer Is This]

Excel 2013 has icon sets in conditional formatting. Would this work for you?

 

[HuskyJones]

Excel 2013 has icon sets in conditional formatting. Would this work for you?

I can only get the icon sets to have green up and red down, in my case I need them the other way round as down is good and up is bad

Can you customise them?

 

[Yongle]

A way without using icons

With
- BaseLine in B2
- PostIntervention in C2

Formula in D2
=IF(C2<B2,"↑",IF(C2>B2,"↓",""))

Condtional formatting rule for cell D2
=C2<B2
apply colour-fill green

 

[My Aswer Is This]

In conditional formatting. Look down at bottom and click on more rules.
Choose Reverse order

 

[Yongle]

To avoid using an extra column

With
- BaseLine in B2
- PostIntervention in C2

Conditional format rule for C2
=B2>C2<b2

Under Format in conditional format
\ Number \ Custom
Under type enter 0 ↑

and apply Colour-fill green

JUST SPOTTED that the board is eating LESS THAN symbol again - so have reversed formula and used GREATER THAN!

=IF(B2>C2,"↓","") is amended formula for post 4

</b2

 

[HuskyJones]

that's brill that works for lower value but how would I do a side arrow and an up arrow for same and higher? guessing a nested if?? how do i enter the arrows as it keeps wanting to put a letter in instead when I paste it?

If I then put the arrows in different cells hidden away (say AB1/2/3) and do conditional formatting, 3 separate rules "format only cells that contain" =if(c2=AB1) format green, =if(c2=ab2) format orange, =if(c2=ab3) format red

sorry i'm being thick! not a good day today lol

 

[Yongle]

@HuskyJones - who are you directing the question to?

 

[HuskyJones]

You please @Yongle
I'm guessing..... =IF(H115>H117,"↓",if(H115<h117,<h117,<h117,"<strong><h117,"<strong>*less than sign*H117,need up arrow</h117,"<strong>",if(H115=H117,"need side arrow","")))
I can't get the arrows into the formula it keeps putting in à and á not the arrows

Done the formatting bit </h117,<h117,<h117,"<strong>

 

[HuskyJones]

** sorted thank you all **