I have a named range and within that named range, one of the columns contains a value that is “TRUE” or “FALSE”. When the column cell contains the TRUE value, I want to be able to shade the corresponding row with a light grey or something (does not matter). Since conditional formatting, as far as I could take it, only applies to cells, I suspect this requires a very simple macro to do this. Any insight that anyone can provide is greatly appreciated. (Point me to something that has already been posted??)
Ron M