Conditional Formatting

P

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
 
D

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.
 
P

Potsy

Hi

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

--
Regards

Roger Govier









- Show quoted text -
Click to expand...

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