Battery Date formuals

[Batkinso]

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

 

[Joe4]

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).

 

[Batkinso]

[TABLE="width: 75"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
thank you this I what I was trying to post
=J10(<)TODAY()-1095

 

[Batkinso]

that formula works for only one cell though. I need it to apply for all cells A1 - AC110

 

[Joe4]

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.

[COLOR=#333333]=[B]$[/B]J10 < TODAY()-1095[/COLOR]

 

[Batkinso]

Yes I am using conditional formatting. and how would I select entire range like where I have J10 would I do it like this instead =$A1-AC110 < TODAY90-1095

 

[Joe4]

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?

 

[Batkinso]

F1 is the first cell that I want this applied too.

 

[Batkinso]

Let me know if you can see the image I tried to attach

 

[Joe4]

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.