Adding the Conditional Formatting in Office 2007/2010
Adding the Conditional Formatting in Office 2007/2010
|
From the Home tab, click on Conditional Formatting, New Rule
Select “Use a formula to determine which cells to format”
And then type the formula
=COUNTIF($C:$C,E23)=0
(where Column C is the column that we are comparing with and E23 is the first cell of the data that we have highlighted. This formula works for any comparison of data between 2 columns – you just have to adjust the Column that you are comparing with and adjust the cell of the first entry of your data)
Click on the Format button on the Conditional Formatting box.
Choose the format of the font if the selection differs from the entry you are comparing with. In this case, any entries in column E that don’t match the corresponding entry in column C will be red and bold.
Click on OK
Click on OK again
|
|
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 ...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 ...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 ...Setting Macro Security - MS Office 2007
Office 2007- Setting Macro Security Excel 2007 works differently than previous versions of Excel. In order to allow the buttons and macros to work correctly in your CCI spreadsheets, you will need to complete the procedure listed below on each PC ...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 ...