select cells based on color

  • Thread starter Thread starter lachlanmullen
  • Start date Start date
L

lachlanmullen

is there a way to select cells in an excel spreadsheet based on thei
background color? for example, i want to change cells background colo
to gray from yellow.

any ideas?

~Lac
 
'if yellow then make it gray
Try this:

if selection.interior.colorindex=27 then
selection.interior.colorindex=16
end if


regards
mark
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formula formatting 2
How do I invoke a call in Excel 4
Excel: Remove color background from cells, restore grid. 2
Change background color of cell based on vlookup in cell 1
Changing Cell Background Color based on data from another cell 2
Format cell color? 5
Word Globally Changing Specific Color Highlight to Background Color 0
Conditional Formating based on Date 5

Back
Top