Match entire row to first cell in row (formatting wise)

[NewYears1978]

I use conditional formatting a lot but I have not been able to figure out how to make a row copy the formatting from the first cell in the same row (and then extend that to all rows)

[NBVC]

In your conditional formatting formula you need to make the column absolute by adding the $ before the column identifier, e.g $A1
Then you need to change your "Applies To" range to include all columns to affect.

[NewYears1978]

Ahhh Let me attempt that. I feel stupid lol.

I guess I have never done this before. When I add $ in the column identifier it just reverts back? Sorry for my "newbishness"

I got it using a cell value but not sure how to match the formatting.

[JeteMc]

As an example use Conditional Formatting formula rules:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

both applied to =$A$1:$D$2 Notice all cells in both rows will have the same fill, font style and font color when the letters are interchanged.
If this doesn't do what you want it would probably be best to upload a sample spreadsheet that has been manually formatted in accordance with what you'd like CF to do.

[NewYears1978]

Sorry for the slow reply, had a busy week. It works as you guys have said, thanks so much, this makes my work day a lot easier

[JeteMc]

You're Welcome and than you for the feedback. If that takes care of your original question, please select Thread Tools from the menu link above your first post and mark this thread as SOLVED. I hope that you have a good day.