gr8whthunter76
New Member
- Joined
- Feb 16, 2021
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
Here is the issue. I copy and paste from a adobe file to excel a big report. I have figured out he to highlight numerical differences using conditional formatting, but I can't figure out my first column which has the months in it. The months that copy in are the months in text so A12=July, A13=Aug, A14=Sep and so on. What I would like to do is if there is a month missing then highlight that cell. I found this formula, =A2<>(A1+1), which works if you are using sequential days, but does nothing for sequential months if they are missing. This came about in a 300 line report right about 2/3's of the way through the months skipped from May to Aug and I didn't notice it which was an issue.
Any advice on a formula??????
Any advice on a formula??????