Highlight a cell if another cell in the row has been manually highlighted

[adambc]

I have a Worksheet with 8 columns, A to H ...

Column A is the "control" column ...

Columns B to H are the working columns which may be highlighted in yellow manually ie NOT as a result of a conditional format by the user ...

I want to automatically highlight column A if ANY of the cells in columns B to H in the same row are highlighted ...

Is there a way of doing this?

Thanks ..

 

[offthelip]

I have written a useful UDF which counts the number of cells in a range which match a certain color. you could use this combined with conditional formating to achieve the result you want.
this is the UDF

Function countByColor(CellColor As Range, rRange As Range)
Application.Volatile
Dim cSum As Double

Dim ColIndex As Integer
ColIndex = CellColor.Interior.ColorIndex
For Each cl In rRange
If cl.Interior.ColorIndex = ColIndex Then
cSum = cSum + 1
End If
Next cl
countByColor = cSum
End Function

The first range (Cellcolor) is used to select what color you want counted this should be a single cell
the second range is the range where you wanted the colors counted, in your case if this is not zero then conditional formatting can be used to highlight the cell