Apply Conditional Formatting In Excel. Apply Conditional Formatting across Workbook Step 1. Open both workbooks you will apply conditional formatting across select a blank cell you will refer values from another workbook says Cell G2 enter the formula My ListxlsxSheet1A2 into it and then drag the AutoFill Handle to the range as you need.
Here we have a table that contains employee data. Formatting comprises of the foreground color background color font size etc. In Excel Conditional Formatting can be found in the Ribbon under Home Styles ALT H L.
For this we will create a rule in excel Conditional Formatting based on cell value.
Select the cells you want to format. For this we will create a rule in excel Conditional Formatting based on cell value. Conditional Formatting in VBA. Or you can type the formula Book2xlsxSheet-PassA2 into any cell next to table1 to get values from Book2 table2.