Identify if any cell in a row is highlighted

[Liz_I3]

Hi I have a spreadsheet with data on rows B2 to T200. I have applied conditional formatting to many columns and would like to identify in Column" A" beside each row if any of the cell in that row in any column of that row (example B2:T2) are highlighted. Not fussy on how it is identified , Yes, No, True , False . Have been trying but no success.


Thanks
L

 

[MountainFog]

Unless you use Vba, you can't check the fill value of a cell. Instead put a formula that checks the condition in your conditional formatting:

=If(CONDITIONAL FORMATTING FORMULA, "Highlighted", "Not Highlighted")

 

[Liz_I3]

Thanks M

Would anyone know a VBA code I could use?