In an example attached 1 represent outage/Absenteeism so in order to find consecutive number like 1 after 1 , twice or thrice . Kindly help
In an example attached 1 represent outage/Absenteeism so in order to find consecutive number like 1 after 1 , twice or thrice . Kindly help
So, what is the question? And why are some cells highlighted Yellow? Some are just below another 1 but some are isolated by itself. i.e. B153, G155.
What is the logic you are looking for and do you want a summary or just conditional formatting?
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Use this as a New Rule, Use Formula...
=AND(B2=1,C2=1)
It will highlight (I used red), each time 2 or more cells contain a 1. It wont highlight the last 1 in the sequence, but will still show the sequence.
IE if 2 1's, 1st will be highlighted
if 3 1's 1st 2 will be red etc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks