Excel fill colour advice

I

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,752
Office Version
  1. 2007
Platform
  1. Windows
How can i find out what value this grey is please.
Part of my code is to use this colour using vba but im not sure what it is.


EaseUS_2024_08_24_12_30_21.jpg
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Click More Colors, then the Custom tab, and you will be able to see the RGB values that you can use in VBA.
 
Upvote 0
I see that but how can i find out the grey in question so i can use the same value ?

What is the RGB value for the grey i pointed out ?
 
Upvote 0
If you filled the selected cell with that colour, the more colours dialog will default to that colour value, so the RGB values will be what you need.
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

T
  • Question Question
Making a cell mandatory to fill before being able to fill in another cell with a drop-down
Replies
3
Views
123
mumps
mumps
D
  • Solved
Conditional Formatting Using VBA
2
Replies
15
Views
165
DanteAmor
DanteAmor
R
  • Question Question
Advice required for dynamic master table
Replies
0
Views
291
RichPinn
R
M
  • Solved
VBA to clear cell contents and conditional formatting but retain the formula
Replies
5
Views
354
MLC1980
M
V
  • Question Question
Excel: drop down list colouring based on "dependent" list
Replies
5
Views
160
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,954
Messages
6,175,601
Members
452,658
Latest member
GStorm

Share this page

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