Changing Color of Data Set Icon

Hydestone

Board Regular
Joined
Mar 29, 2010
Messages
137
I have some data that requires conditional formatting for easy interpretation. I'd like to change the color of the symbols from blue to red. Is that possible?
Book2
EFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
25550254646372925203226222020161610101010101010181880000
3664533333332222222222222111111
442424212121212121218188888880000000000000
538333659555147473737344646464848363636363636363628281616##
651511632403220161438423220181812121212121818182626161616##
760605656565656565858585050505050504646464646444444442424##
8987776533321000011111111111111
944443634262626262626262626262626262626262626262626262020##
1054494450363636363636362020202020202020202020202020202020##
1146402828282828242424241288881466666121212121212##
124949635554545454444424242418888888888888151500
1344444444444452525252424242424242502626262626262626261212##
14282844444436362626262610101010101010101010101010000000
1544302642322424243232323228323216181414141414161616161616##
164650266161616242424243030303028281616161616161616161616##
1712119878887667776775544444444433
18401818262626261620202020202012000000000000000
195034384846383846524444404056222828101010101000000000
2049383836444434343428283232323240403212121212121212121212##
2142346264647266666666666666606072727272686868686844444444##
2240404032323232121212121212120000000000000000
23393939473636363644444444444440402420120016161616161616##
2440286066989894865858585858484860606060606060606060606060##
252422221824322820282828282828282820242400000000000
2625252537363636202020202020202080000016161616161616##
27363636363636363636363636363636363232161616161616000000
28999988767777766644322333222222
data sets
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E2:AH28Other TypeIcon setNO
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
1703012200657.png
 
Upvote 0
There is noway to change the colour of that icon set.
 
Upvote 0

Forum statistics

Threads
1,215,137
Messages
6,123,254
Members
449,093
Latest member
Vincent Khandagale

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