I have a worksheet with many cells that need to be address individually,
either numerically or otherwise. How do I conditionally highlight cells that
have not been addressed? A cell that contains the numeric value 0 (zero) has
been address, whereas an empty cell has not. It is a pain visually scanning.
It is also an option to highlight cells that have been address either
numerically (including 0) or otherwise.

Thanks Guys and Gals if you could help

highlight all the cells that need to have info in them. Make note of which
cell is active (for example, I'll use A2).

Format - Conditional Format, formula is:
=ISBLANK(A2)
Set desired formatting.
Ok out.

Similarly, you could use the following two conditions:
=ISNUMBER(A2)

=ISTEXT(A2)

To check whether the cell contains a number or just regular text.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Owen P" wrote:

> I have a worksheet with many cells that need to be address individually,
> either numerically or otherwise. How do I conditionally highlight cells that
> have not been addressed? A cell that contains the numeric value 0 (zero) has
> been address, whereas an empty cell has not. It is a pain visually scanning.
> It is also an option to highlight cells that have been address either
> numerically (including 0) or otherwise.
>
> Thanks Guys and Gals if you could help

You have a choice of two CF conditions:
=ISBLANK(A1) if you want to exclude cells with the empty string ""
=A1="" will highlight both totally empty cells and those with the empty
string ""
--
David Biddulph


"Owen P" <Owen (E-Mail Removed)> wrote in message
news:A398EF81-53D3-4EEE-A1FF-(E-Mail Removed)...
>I have a worksheet with many cells that need to be address individually,
> either numerically or otherwise. How do I conditionally highlight cells
> that
> have not been addressed? A cell that contains the numeric value 0 (zero)
> has
> been address, whereas an empty cell has not. It is a pain visually
> scanning.
> It is also an option to highlight cells that have been address either
> numerically (including 0) or otherwise.
>
> Thanks Guys and Gals if you could help