Can you reference another sheet in conditional formatting?
In earlier versions of Excel, you can’t refer to another sheet in conditional formatting or data validation. With data validation, you can’t even click on the other sheet, to try and create a reference. In conditional formatting, you can enter the reference in the dialog box, but then Excel yells at you.
How do I apply conditional formatting between two Excel spreadsheets?
Applying Conditional Formatting On the Home tab of the ribbon, choose the Conditional Formatting drop-down menu and select New Rule. In the New Formatting Rule window, select the option that says Use a formula to determine which cells to format.
Can you use conditional formatting in a table?
Conditional formatting works well in a table, but you can’t use structured references directly when you create the rule.
Can I copy and paste conditional formatting in Excel?
Right-click anywhere inside the selected area. To copy only the conditional formatting, move your mouse over Paste Special, then choose Paste Special from the new menu that appears. Click the radio button next to Formats and click OK. To copy the contents and the formatting, choose All merging conditional formats.
How to use conditional formatting on two sheets?
Compare Cells on Two Sheets. In this example, you’d like to highlight the cells on Sheet1, if they’re higher than the matching cell on Sheet2. Select cells A1:C8 on Sheet1, with A1 as the active cell. On the Ribbon, click the Home tab, and click Conditional Formatting. Click Highlight Cell Rules, then click Greater Than.
When to highlight a cell in conditional formatting?
In this example, you’d like to highlight the cells on Sheet1, if they’re higher than the matching cell on Sheet2. The cells on Sheet1 are now highlighted if their value is higher than the matching cell on Sheet2. In earlier versions of Excel, you can’t refer to another sheet in conditional formatting or data validation.
How to use conditional formatting with data validation?
With data validation, you can’t even click on the other sheet, to try and create a reference. In conditional formatting, you can enter the reference in the dialog box, but then Excel yells at you. However, you can refer to named ranges anywhere in the workbook, in both conditional formatting and data validation, so you can use that as a workaround.
Where do you enter named ranges in conditional formatting?
In conditional formatting, you can enter the reference in the dialog box, but then Excel yells at you. However, you can refer to named ranges anywhere in the workbook, in both conditional formatting and data validation, so you can use that as a workaround.