how do i format a cell based on format of a range of cells?
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
"CLR" wrote:
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
"Chris Hardick" wrote:
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
|