Forum Discussion
Automatic Input of data based on if cells have color in them or not
I am having trouble trying to come up with a function or IF statement that will input an "x" in a cell on the side indicating that the row has a colored cell in it. The colored cells already have conditional forming applied to it that tells the cell to color itself after a certain date range has been reached by the date already in the cell. I would like for the "x" to be in column M please and thank you.
- You may put the same formula of cknditional formating to the column m. if(that_formula,"X",""). Of course, you may need to change a bit in the formula if necessary.
how would I do that? I just typed in if(that_formula,"X","") into the next cell, but nothing is happening :)
I am sorry, I misunderstood.
Try to put the following in the Column M
=IF(SUMPRODUCT(($A1:$K1>=TODAY()-730)*($A1:$K1<=TODAY()+45)),"X","")
