Customise Icon Sets

HuskyJones

New Member
Joined
Sep 30, 2015
Messages
41
Office Version
  1. 365
Platform
  1. Windows
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 :)
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Excel 2013 has icon sets in conditional formatting. Would this work for you?
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
In conditional formatting. Look down at bottom and click on more rules.
Choose Reverse order
 
Upvote 0
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:
Upvote 0
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
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top