Conditional Formatting formula

[Myna]

Hello

I have attached a formula example.
I have this conditional formatting formula: =AND(ISNUMBER(C4:K4),ISNUMBER($L4)) when I put any number on cells C4 to K4 a soon as I put any number in cell L4 it becomes red.

I need the same formula BUT excluding number ZERO (0) All cells C4:K4 and L4 excluding zero.

Do I need a new formula to work with this one or can I use this one modified?
Anyone knows how to do it?

Many thanks in advance.

Myna

[TMS]

Maybe:

=AND(ISNUMBER(L17),SUM(C17:K17)<>0)


Regards, TMS

[Myna]

Thank you very much for your reply.

With your formula: =AND(ISNUMBER(L17),SUM(C17:K17)<>0), any cell with 1 or higher cell L17 becomes red.
I dont want any cell with 1 or higher, I need ALL cells filled with numbers 1 or higher for the L17 become red. L17 red only when ALL cells have numbers.

Also cell L17 RED ONLY when I put number 1 or higher.

Any ideas

Myna

[huuthang_bd]

Try this:

Please Login or Register  to view this content.

[bebo021999]

Try this:

Please Login or Register  to view this content.

@huuthang_bd
Thức khuya thế !
A slight amendment in your formula

Please Login or Register  to view this content.

to count the minus.