I am trying to write an If statement that would search a column for cells that have red as a background color, and if they did, would mark the cell with an X. Does anyone know a formula I can use to accomplish this?
The CF I am using is if the cell has a date that is less than today's date (is in the past or is "overdue"), then I color the cell red. I reference a cell with =TODAY() in the CF, and put Cell Value is less than the cell with the current date.
That would work out perfect if I only had one conditional format, but I actually have 2 and am filling in some cells manually as well. I'm dealing with dates, when people are giving me updates...if a date has moved out more than one month, when I update the spreadsheet I manually make the cell red.
So, is there any way to solely look at a column, and write a formula to check the background color, and if it is red...return an X?