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