Conditionally formatting a row with relative references doesn't work!?

[jdmc45]

Hi,

I am trying to conditionally format an entire row (and all subsequent rows) based on a criterion for the first cell to be one of either of three text values, say "a", "b" or "c". When the formatting is done however with relative references only the first cell (which the criterion is based on) is highlighted. How do I get the whole row to be conditionally formatting, with relative references, as I want to use the format painter to copy down the formats?

If someone tells me how to add the spreadsheet to a post I will include the spreadsheet which I'm sure will take one of you a matter of seconds to figure out.

Thanks!

 

[T. Valko]

based on your last post. If you select A1 to D5, and create the following 3 different conditional formatting formulas in A1, I think is what you are looking for.
=AND($a1="a") format blue
=AND($A1="b") format green
=AND($A1="c") format yellow
Then if you highlight D1:D5 and copy it down all of the formats will follow.

Mr. Bill Thanks for that, it was the AND function that was needed for it to apply to the entire row, cheers!

The AND functions in those formulas are superfluous. They're not needed.

=$A1="A"
=$A1="B"
=$A1="C"