I haven't tested this, but if you just select columns A to L and enter the formula you already have, then that should work OK. (n.b. if you have conditionally formatted the entire sheet, you will need to delete the formatting first then do the above).
Like this thread? Share it with others