how do i format a cell based on format of a range of cells?

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

Guest

A group of 20 adjacent cells within a row are manually colour coded based
upon status. There is a priority associated with the color(5 levels).
I would like to change background colour of other cells within the row to
match the highest priority colour
I have looked at conditional formatting but it does not give ability to
check a cells formatting, only its contents
Any suggestions will be gratefully accepted
 
Hi Chris...........
Five levels of conditional formatting can be attained with VBA, but one must
still specify the criteria for the Priority Assignment.....if not the
contents of a cell, then perhaps another column devoted to Priority.

hth
Vaya con Dios,
Chuck, CABGx3
 
Thanks for the response, unfortunately I have no experience of VBA.
Can you point me at a good online resource covering the basics of VBA with
EXCEL

Thanks
 
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 formatting in Excel 2010 2
Question about conditional formatting of zeros in Excel 0
conditionally formatting cells based on other cells 1
format cells depending on value range 5
Conditional formatting 3
Conditional Formatting of a Row 2
Conditional Formating based on Data Validation 3
cell formatting 3

Back
Top