I have used conditional formatting across a range of cells and one of the criteria is formatting the first blank column red.
example in column F, the conditinional format formula inserted is =(((D4-C4)/C4)<=$C$29) where C29 is 0. If column G is blank (awaiting new figures) then it is formatted red. I would rather it remained unformatted. Any suggestions?
example in column F, the conditinional format formula inserted is =(((D4-C4)/C4)<=$C$29) where C29 is 0. If column G is blank (awaiting new figures) then it is formatted red. I would rather it remained unformatted. Any suggestions?
