if cell colour is then change cell colour in range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a macro that changes the cell colour in a range of cells
based on the cell colour in the row.
 
hi,
could you be more specific. does range of cells mean a block of cells? if
so, how bigs? based on what row? more info please.

regards
FSt1
 
Sorry,

I have a cell identified by either the word "Unbene" or the interior cell
colour.

I want to write a macro that will identify that cell and then colour 9 cells
in the same row.

The word is in cell C and I want cells A-I change to a colour I designate.

Is this clearer?
 

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

VBA set thick borders around non empty cells in range 0
Cell colour format according to date 1
function to re-calculate when cell format (colour) changes 1
Colour format code 2
Macro to change cell colour based on words 3
Re. Conditional formating of adjacent cells but down a column 0
Microsoft Excel VBA: Concatenate without formatting 1
Conditional Formatting VBA with formula to find string 3

Back
Top