No problem! Try changing the second condition too

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



"mmills421" wrote:

Ok, working now. One last question though, now all cells are red unless the
GREEN conditions are met. I want all rows that don't have column A values to
appear clear. Once a value is put into column A, I want the GREEN/RED rules
to apply. GREEN and RED are for the "X" value in columns B-F, but nothing
should apply if column A is blank. I appreciate all your help by the way...

"akphidelt" wrote:

Ohhhh, ok then change the formula from

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

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

Basically just change And to Or

"mmills421" wrote:

Actually, the RED formula works, but only if the none of the cells contains
an "X". I would like it to highlight RED if and single cell does not contain
an X, so that the row would be highlighted RED until ALL cells contain an
"X", at which point the row will switch to GREEN.

"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.