Home

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

Highlighted
Vincent Santini
Occasional Visitor

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.

 

 

 

3 Replies

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

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.

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

how would I do that?  I just typed in if(that_formula,"X","") into the next cell, but nothing is happening :)

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

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

 

Related Conversations