I am trying to find a formula for all cells that can take my battery dates that are 3 years old of the current date and or older that show highlighted red. I have used the formula =J10<TODAY()-1095 and it works for one cell but I cannot figure out how to us it for all cells. Please help
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,249
- Office Version
- 365
- Platform
- Windows
I am guessing that you are having this issue posting: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html
Surround your greater than ( > ) and less than ( < ) symbols by spaces, and they will post properly (and not be intepretted as HTML code).
Surround your greater than ( > ) and less than ( < ) symbols by spaces, and they will post properly (and not be intepretted as HTML code).
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,249
- Office Version
- 365
- Platform
- Windows
Are you using Conditional Formatting?
If so, then select the entire range that you want to apply it, then write the formula as it pertains to the very first cell in your selection.
Excel will automatically adjust it for others. Just note that if you need to lock the column references down so it always looks at column J, you will need to add the absolute reference sign ($) in front of it, .i.e.
If so, then select the entire range that you want to apply it, then write the formula as it pertains to the very first cell in your selection.
Excel will automatically adjust it for others. Just note that if you need to lock the column references down so it always looks at column J, you will need to add the absolute reference sign ($) in front of it, .i.e.
Code:
[COLOR=#333333]=[B]$[/B]J10 < TODAY()-1095[/COLOR]
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,249
- Office Version
- 365
- Platform
- Windows
OK, I am not quite clear on the specifics of what you are trying to do, so let's establish that. If you show me a few examples, I should be able to see the pattern.
So let's start this way:
- What is the address of the 1st cell that you want to apply this Conditional Formatting to?
- What would the Conditional Formatting formula for that cell look like?
- What is the address of the 2nd cell that you want to apply this Conditional Formatting to?
- What would the Conditional Formatting formula for that cell look like?
So let's start this way:
- What is the address of the 1st cell that you want to apply this Conditional Formatting to?
- What would the Conditional Formatting formula for that cell look like?
- What is the address of the 2nd cell that you want to apply this Conditional Formatting to?
- What would the Conditional Formatting formula for that cell look like?
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,249
- Office Version
- 365
- Platform
- Windows
No, I cannot see your image.
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
However, I don't think an image is necessary here. If you can just answer the questions in my previous post, I think we should be able to do it.
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
However, I don't think an image is necessary here. If you can just answer the questions in my previous post, I think we should be able to do it.
Upvote
0
Similar threads
- Question
