Automatic Input of data based on if cells have color in them or not

Copper Contributor

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.

 

 

 

3 Replies
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","")