Difference of empty cell and zero value when formatting

A

Al

I'd like to conditionally format a cell if the value zero is entered into it,
however to leave the cell without formatting if the cell if empty. My
attempts at doing so using something like formula is =q54=0 format the cell
regardless of whether the cell has a zero or is empty!

Appreciate any help...thanks!
 
A

Al

Works perfectly....so this is saying if the cell is not blank, and is equal
to zero, then true, so apply formatting, as apposed to if it is ony blank,
which would produce a false?

Brilliant...thank you, and so quick!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top