Conditional Formatting

  • Thread starter Thread starter Potsy
  • Start date Start date
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
 
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

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