Customise Icon Sets

HuskyJones

New Member
Joined
Sep 30, 2015
Messages
31
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 :)
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,874
Office Version
  1. 2013
Platform
  1. Windows
Excel 2013 has icon sets in conditional formatting. Would this work for you?
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,781
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jul 5, 2014
Messages
16,874
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

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

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,781
Office Version
  1. 365
Platform
  1. Windows
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! :mad:

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

</b2
 
Last edited:

HuskyJones

New Member
Joined
Sep 30, 2015
Messages
31

ADVERTISEMENT

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
 

HuskyJones

New Member
Joined
Sep 30, 2015
Messages
31
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>
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,450
Messages
5,528,819
Members
409,839
Latest member
akashsadhu
Top