Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Potsy - 16 Jul 2007 11:54 GMT

Hi

I would like to be able to hide A33 and J33 if I33 is null via
conditional formatting in white.

I have tried setting Formula is : =I33="" but does not seem to work.
Any ideas????

Potsy

Reply to this Message

Dave Peterson - 16 Jul 2007 12:34 GMT

It worked for me.

You may want to try again. If it doesn't work, post more details of what you
tried.

And you're sure I33 is blank--not made to look blank with a space character.

=trim(i33)=""

may help if that's the case.

> Hi
>
[quoted text clipped - 5 lines]
>
> Potsy

Signature

Dave Peterson

Reply to this Message

Roger Govier - 16 Jul 2007 12:37 GMT

Hi

Highlight cells A33 and J33 and in conditional formatting set =$I33=""

Signature

Regards

Roger Govier

> Hi
>
[quoted text clipped - 5 lines]
>
> Potsy

Reply to this Message

Potsy - 16 Jul 2007 12:59 GMT

On 16 Jul, 12:37, "Roger Govier" <ro...@technologyNOSPAM4u.co.uk>
wrote:

> Hi
>
[quoted text clipped - 16 lines]
>
> - Show quoted text -

Thanks was entering "0" and was set as percentage in format therefore
not seeing as empty. When i select cell and hit delete key works
fine!!!

Reply to this Message