I need a formula for "true" or "false" based on whether or not a row has a color filled cell. I have conditional formatting applied throughout my workbook and I need a formula that's going to mark which rows in the spreadsheet contain a color fill (could be single cell or numerous per row, doesn't matter, just needs to mark the rows that contain color fill). Obviously I can see which cells are color filled with conditional formatting but with so much data I need a "true" or "false" column that will allow me to easily filter blank rows (no color fill) vs rows that have cells that contain color.
Thanks!
Bookmarks