Colour formating

lazarandreiflorin

New Member
Joined
Dec 16, 2018
Messages
34
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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
After seleting the 2 range, in CF put formula:

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

and

=$L4="x" and fill red
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
How about
=COUNTIF($L4:$X4,"X")>0 for red
and
=COUNTIF($L4:$X4,">0")>0 for green
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top