Using Conditional formatting to highlight Pay Group differences in the Payroll Deductions sheet for ISIS

Using Conditional formatting to highlight Pay Group differences in the Payroll Deductions sheet for ISIS

Using Conditional formatting to highlight Pay Group differences in the Payroll Deductions sheet for ISIS

Highlight the data in the column that you want to compare. Hint – place you cursor on the bottom border of the cell and hold the shift key and double click)

From the Home tab, select Conditional Formatting, Highlight Cell Rules and then More Rules…


Select “Use a formula to determine which cells to format”

Enter the formula as shown. 

=AB4<> OFFSET(AB4,0,-1)





In this case cell AB4 is the top cell for the column that we want to compare with.  This formula tells excel to compare AB4 with the cell to it’s left (offset(AB4,0,-1) where the -1 is the column offset.  The formula will adjust for all rows.

Click on the Format button.






Select a color such as red.

Click on OK twice.



Entries that are different will now be highlighted

    • Related Articles

    • Conditional Formatting – Highlighting differences in information

      Conditional Formatting – Highlighting differences in information In this example, we will show how to use conditional formatting to highlight differences in data. We will use the Payroll History spreadsheet to show salary amounts from month to month ...

    • Conditional Formatting – Highlighting differences in information

        Conditional Formatting – Highlighting differences in information In this example, we will show how to use conditional formatting to highlight differences in data. We will use the Payroll History spreadsheet to show salary amounts from month to ...

    • Determining the Average Voluntary Deduction per check

      Determining the Average Voluntary Deduction per check Refresh using the desired data range Click on the Payroll History Pivot Table. The information that we will need on the pivot table is the check number ( so that we can count the number of checks) ...

    • Using the Sartox Deductions spreadsheet

      Using the Deductions Spreadsheet (Sartox) In Sunpac, go to options:  3, 33, 5  The Sartox Deductions spreadsheet is based on information obtained in a file after running the Sartox Deductions register in Sartox.  Therefore, prior to opening the ...

    • Comparing Months of Information in the CCI Spreadsheets(Example uses Sartox Deductions Register)

      Comparing Months of Information in the CCI Spreadsheets(Example uses Sartox Deductions Register) Refresh your spreadsheet so that it includes multiple months of information. We are using the Sartox Deductions Register for this example, but this ...