Page 1 of 1
ASk DS- Microsoft Excel Question
Posted: Fri Apr 10, 2015 2:36 pm
by matador1
I remember we had a couple of people on here with some Excel skills. Call C1 is a cell I am entereing a Date ordered. I want that C2 to turn red if nothing has been entered in it wihtin 2 days to alert my processor to call and check on why. How does my formula read?
Re: ASk DS- Microsoft Excel Question
Posted: Fri Apr 10, 2015 4:54 pm
by stang67
You need conditional formatting, in addition to a formula, I believe.
You should make one cell, say at the top of the page, that always has the current date (there's a formula for that). Then the cell in question could be the order date minus the current date. Then your conditional formatting could make the cell red if its value is greater than 2. Something like that.
Re: ASk DS- Microsoft Excel Question
Posted: Fri Apr 10, 2015 6:54 pm
by bama.hunter
Stang67 is right, but to save you sometime goggle it and 99% of the time you can did a YouTube video to walk you through the process from start to finish.