If you highlight all the rows of your data and you keep the $ sign in front
of the column letter, you should only have to type the equation in once.

And remember if your data does not start in A1 then change the 1 to whatever
row your data starts in.

As for way the second formula is not working I am not sure. Can you post the
formula here... and then let me know where the conditional formatting starts?

"mmills421" wrote:

Thanks, it worked for the 1st condition (GREEN) but not for the second
condition (RED). I double checked the formula and it looks correct.

Also, how would I get this to apply to all rows, without having to re-type
conditions for each, i.e. A1, B1, C1 and then A2, B2, C2.

"akphidelt" wrote:

Alright, highlight the complete row around all your data...

Go to Format--Conditional Formatting

Change it to Formula Is

For example if the first row of your data starts on A1 to D1

Type in
=And($A1="X",$B1="X",$C1="X",$D1="X")

Make sure you keep the $ sign in front of the column
Then for the no X do the same thing but replace the = sign with <

=And($A1<"X",$B1<"X",$C1<"X",$D1<"X")


"mmills421" wrote:

Dumb user here. I want to set a conditional formatting (?) rule so that a
row will highlight a certain color depending on if certain cells contain a
character (X). Example, if A1, B1, C1 and D1 each contain "X", the row will
highlight GREEN. If "X" is not contained within each of the cells, the row
will highlight RED.