Full feature free trialģ0-day, no credit card required! Get It Nowĭemo: apply conditional formatting across worksheets/workbooks See screenshot:ģ00 handy tools for Excel. So far the range in the current worksheet has been conditionally formatted based on values from another worksheet/workbook. And then a dialog box comes out and shows how many rows have been selected, just click the OK button to close it. Note: If both ranges you selected contain same headers, please check the My data has headers option.ģ. (6) Check the Select entire rows option as you need. (5) In the Processing of results section, check the Fill backcolor option, and specify a fill color from below drop down list. (4)In the Find section, check the Same Values option (3) In the Based on section, check the Each row option (2) In the According to box, select the column you will apply conditional formatting based on from another worksheet or workbook ( Tip: If you can’t select the column from another opening workbook, you can type the range address directly such as 'Sheet1'!$A$1:$A$10. (1) In the Find Values in box, select the column in the current worksheet you will apply conditional formatting to
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |