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.

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.

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.

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.

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.

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.

Change AND to OR in the RED formatting formula, or merely make RED the
default format, which would apply unless the GREEN condition were met.
--
David Biddulph

"mmills421" wrote in message
...
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.

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.

OK, thanks for the help. One last question though. All rows that don't have
required "X" value appear RED, but I would like the RED/GREEN rules to only
apply after a value is entered into column A. The "X" columns are B-F, so I
would like the RED/GREEN rules to be "activated" if something is written in
column A. Until a value is in column A, the rows should appear clear. I
appreciate all of your help...

"akphidelt" wrote:

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.

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.

=AND(A1<"",...
--
David Biddulph

"mmills421" wrote in message
...
OK, thanks for the help. One last question though. All rows that don't
have
required "X" value appear RED, but I would like the RED/GREEN rules to
only
apply after a value is entered into column A. The "X" columns are B-F, so
I
would like the RED/GREEN rules to be "activated" if something is written
in
column A. Until a value is in column A, the rows should appear clear. I
appreciate all of your help...

"akphidelt" wrote:

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.

That is almost working, but when I enter a value in column A of a row, the
row underneath becomes active (highlighted RED), not the actual row in which
the value was entered...

"David Biddulph" wrote:

=AND(A1<"",...
--
David Biddulph

"mmills421" wrote in message
...
OK, thanks for the help. One last question though. All rows that don't
have
required "X" value appear RED, but I would like the RED/GREEN rules to
only
apply after a value is entered into column A. The "X" columns are B-F, so
I
would like the RED/GREEN rules to be "activated" if something is written
in
column A. Until a value is in column A, the rows should appear clear. I
appreciate all of your help...

"akphidelt" wrote:

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.

In which case you need to look again at your CF formula, to make sure that
whichever cell you are trying to format is affected by the appropriate cell.

It sounds as if you've formatted row 2 with a formula referring to row 1.
--
David Biddulph

"mmills421" wrote in message
...
That is almost working, but when I enter a value in column A of a row, the
row underneath becomes active (highlighted RED), not the actual row in
which
the value was entered...

"David Biddulph" wrote:

=AND(A1<"",...
--
David Biddulph

"mmills421" wrote in message
...
OK, thanks for the help. One last question though. All rows that
don't
have
required "X" value appear RED, but I would like the RED/GREEN rules to
only
apply after a value is entered into column A. The "X" columns are B-F,
so
I
would like the RED/GREEN rules to be "activated" if something is
written
in
column A. Until a value is in column A, the rows should appear clear.
I
appreciate all of your help...

"akphidelt" wrote:

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.