select cells based on color

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
 
M

Mark E. Philpot

'if yellow then make it gray
Try this:

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


regards
mark
 
Top