Nov 27 2017
10:21 AM
- last edited on
Jul 25 2018
10:28 AM
by
TechCommunityAP
Nov 27 2017
10:21 AM
- last edited on
Jul 25 2018
10:28 AM
by
TechCommunityAP
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.
Nov 27 2017 08:06 PM
Feb 07 2018 11:15 AM
how would I do that? I just typed in if(that_formula,"X","") into the next cell, but nothing is happening :)
Feb 07 2018 03:15 PM
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","")