MrExcel MVP, Moderator
- May 28, 2005
- Office Version
However when I delete columns say 3 of the 10 ...
OK, so I didn't understand because you talked about deleting columns when it now appears you meant deleting rows... delete a row or two say A2 and A9 in your example.
So try removing the previous CF from the column then apply this to say A1:A1000. When you delete rows, you also delete the CF that is in those rows so if you end up deleting enough rows you will eventually end up with insufficient cells with the CF.... I am highlighting the closest thee to zero by using a different color for each ..
You will need to be careful with the order and/or the 'Stop if true' condition for these three rules.
CF Near Zero (2)