CF Formula : Allowed 0 (Not highlighted red)

[muhammad susanto]

hi all.

how to make formula in CF
- if cell contains 0 --- not highlighted red..
- if cell contains not 0 - highlighted with red

thanks in advance..

.susanto

 

[Joe4]

Is it EXACTLY equal to 0, or just that 0 is contained anywhere in the entry?
Are your entries text or numeric?
Can you provide a few entry examples?

 

[muhammad susanto]

this my target

https://imgur.com/5SlFkIW

 

[Joe4]

My workplace blocks those sites and all file download sites.
Can you just answer the three questions I asked?

 

[muhammad susanto]

if data entry exactly 0, NOT highlighted red...otherwise if blank, any text or any number entries are highlighted red

 

[Joe4]

Try this formula:

=OR(A1<>0,LEN(A1)=0)

and choose your red formatting option.

 

[BGY23]

High light range and in Formual box from CF i.e.

A1<>0

Select the fill you want

Anthing ther than 0 will reult in fill red. It will NOTfill blank cells

 

[muhammad susanto]

hi Joe....not fully working if data blank should be red formatting...

 

[Joe4]

hi Joe....not fully working if data blank should be red formatting...

Go back and look at my previous reply.
I had originally used an AND statement, but that was not picking up the blanks.
I changed it to an OR statement, but you must have seen my reply before the update.

 

[muhammad susanto]

hi Joe,,,great working well!!!

=OR(A1<>0,LEN(A1)=0)

thank you so much...