Conditional Formatting

[Potsy]

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

 

[Dave Peterson]

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.

 

[Roger Govier]

Hi

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

 

[Potsy]

Hi

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

--
Regards

Roger Govier









- 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!!!