Conditional Formatting

**sctraffic** · 06-21-2012, 02:28 PM

Hi,

In the attached table, I am trying to compare the values in cells A2 through A13 to the values in A1 for each column. If a cell is not the same value, I would like to see that cell shaded. If the cell is the same value or is blank, I don't want it shaded. Thanks in advance for any suggestions you provide.Book1.xlsx

**NBVC** · 06-21-2012, 03:25 PM

Select A2:P13, go to Home|Conditional Formatting|New Rule

Select Use a formula to determine which cells to format

enter formula:

=AND(A2<>"",A2<>A$1)

click Format and choose form Fill tab.

Click Ok.

Click Ok again.

**sctraffic** · 07-09-2012, 08:34 AM

That worked great. Thanks for response. In working with it a little more, is there a way that it can be copied conveniently. I want to copy the formatting for those rows, paste it below the original, and have the comparison row adjust automatically. Thanks again.

**NBVC** · 07-09-2012, 08:38 AM

Did you pick the whole range: A2:P13 before applying the formatting? If so, it should apply to all.

If not, you can go to Manage Rule, and edit the Applies to range to include the whole range... the formula will self adjust.

**sctraffic** · 07-09-2012, 10:18 AM

Sorry, I didn't explain myself very well. I am looking to copy rows 2 through 13 and paste in cell A14. Then, I have to edit the conditional rule to compare it to row 14. Since I plan on copying/pasting these rows multiple times I was hoping there was a more convenient way to achieve this.