Forum Discussion
Excel Conditional formatting
Not sure what your point is. I gave you a conditional formatting rule that worked. You don't acknowledge it in your post, which was over an hour after mine....strange. Was it not working when you downloaded my version?
Sorry for delay in response
Tried what you said on attached file with no success
I noted someone said workíng with dates is a problem.
As I think I said previously I am a rookie at computing, trying to lean at over 70.
Are you able to provide líne by line what to do?
Hey, John...here's a resource that you might find helpful. This website in general is a good one to bookmark, because the owners of the site give good examples of how to use many of the functions and features of Excel. I've linked you here to a page on Conditional Formatting with dates.
https://exceljet.net/formula/conditional-formatting-date-past-due
John_P381475 wrote:
Tried what you said on attached file with no success
But I didn't "say" anything. I gave you a Conditional Formatting rule that worked, didn't it?
I noted someone said workíng with dates is a problem.
That was me. I said that I've always found them tricky or elusive, so I need to experiment.
As I think I said previously I am a rookie at computing, trying to lean at over 70.
I turned 80 myself, very recently. I appreciate the difficulty you may be experiencing, especially if you're learning Excel for the first time.
Are you able to provide líne by line what to do?
First, I'd like to know whether or not the file I sent back to you worked. That file is attached again, at the bottom of this window. If it works, you should be able to open the Conditional Formatting dialog box and copy the rule (or the syntax of the rule) to your own situation.
And here, to help you, is the rule written in that Conditional Formatting dialog box.