Colour formating

[lazarandreiflorin]

Hello,
I have a table of 20 rows and I want each row to format based on what one of the cells might contain. To be more precise for example I have range L23:T23 and V23:X23 (this is the last row of the table). If one of the cells has an “x” in it I want the row to be red and when i delete all of the x’s I want it to be blank but also if after deleting the x’s, in one of the cells there is a number bigger than 0 I want the row to be green. I hope anyone understands what I wrote. I tried to do it with conditional formating but I could nt figure it out. Thank you

 

[lazarandreiflorin]

https://ibb.co/wL6SPKx

 

[Tom.Jones]

Put a file not a pictures.

 

[lazarandreiflorin]

https://we.tl/t-Yz2viiQshQ

 

[Tom.Jones]

After seleting the 2 range, in CF put formula:

=AND($L4<>"X",$L4>0) and fill green

and

=$L4="x" and fill red

 

[lazarandreiflorin]

I see this works only when I put an 'x' or a value bigger than 0 in cell L4. I wanted to work if I type an x or a value bigger than 0 in cell M4 or O4 for example.

 

[Tom.Jones]

After selecting the 2 range, in CF ....

It worked for me.

Put the formula I gave you and choose the color you want.
Then go for the second formula, but here you change the color

 

[Fluff]

How about
=COUNTIF($L4:$X4,"X")>0 for red
and
=COUNTIF($L4:$X4,">0")>0 for green