Hi All.

I have a row of cells which have formulas in (returns numbers, but if the number is zero, it comes back as blank) I need a conditional format that recognises the answers to the formulas, rather than there is some text in the cell.

Ie if the answer to the formula is greater than 0 highlight the cells in blue, if the formula is blank (ie less than 1/blank) then highlight the cells in grey.

I know that your excel skills will find this totally easy, but I am really struggling with this!!

I look forward to seeing all of your fab solutions.

Cheers

Donna