Loop based on fill color

Y

yxz152830

Active Member
Joined
Oct 6, 2021
Messages
393
Office Version
  1. 365
Platform
  1. Windows
Gurus,
first off how do I know exactly what fill color it is? say I have a range of green cells. How do I find out the color code? Thanks!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Range("A1").Interior.Color

will give you the fill color value for cell A1 as an RGB color.
 
Upvote 0
Solution
What exactly is it you ultimately want to do? It may be the case that a loop is not needed at all.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Dynamic Pie Chart Slice Fill
Replies
2
Views
117
KOKOSEK
KOKOSEK
X
  • Question
Need help conditional Formatting color
Replies
1
Views
50
xHBx
X
B
  • Question
Event code to give message box and change color of auto-shape
Replies
4
Views
163
bh24524
B
B
  • Question
VBA Conditional Formatting
Replies
4
Views
305
dreid1011
dreid1011
J
  • Question
Cell Count by Color
Replies
5
Views
182
Fluff
Fluff

Forum statistics

Threads
1,214,979
Messages
6,122,552
Members
449,088
Latest member
davidcom

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