serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,444
- Office Version
- 2007
- Platform
- Windows
Hi,
From OA1:QR1 are the numbers from 1 to 70.
Below that is how many time each number came out and you can see in blue the numbers 34,39,41,42,43,etc... never came out yet.
Column NY are the numbers selected.
In red is the CF of the numbers going up.
In green is the CF for the numbers going down.
So I'm looking for a CF formula from OA6:QR255 that will highlight the number column that are not out yet.
Right now I have this CF formula below that highlight the ends of the table but it doesn't cover all the individual number.
=AND(OA6<>"",OA6>MAX($NY$6:$NY$257))
=AND(OA6<>"",OA6<MIN($NY$6:$NY$257))
Thank you.
From OA1:QR1 are the numbers from 1 to 70.
Below that is how many time each number came out and you can see in blue the numbers 34,39,41,42,43,etc... never came out yet.
Column NY are the numbers selected.
In red is the CF of the numbers going up.
In green is the CF for the numbers going down.
So I'm looking for a CF formula from OA6:QR255 that will highlight the number column that are not out yet.
Right now I have this CF formula below that highlight the ends of the table but it doesn't cover all the individual number.
=AND(OA6<>"",OA6>MAX($NY$6:$NY$257))
=AND(OA6<>"",OA6<MIN($NY$6:$NY$257))
Thank you.