Return a value based on any conditional formatting

[delaney1102]

Hi all,
I have a spreadsheet with about 50 columns and 6000 rows, it's a data dump of production information. About half of the columns have their own individual conditional formatting rules set to highlight fields that need to be reviewed. Every rule is highlighting the cell Yellow. I'm looking for some way to pull only the rows that have any cell with conditional formatting so that instead of scrolling around and filtering on every single column to see if there's any yellow I could maybe put an X in the last row if there's anything highlighted. Or even in the last column, just highlight that cell if any cell in the row has a color? Any ideas?

 

[mart37]

With a macro maybe: Count cells with a color