![]() In the New Formatting Rule dialog box, you need to: Select the cell (says A1) you want to shade based on another cell value, then click Conditional Formatting > New Rule under the Home tab.Ģ. ![]() You can do as follows to shade a cell based on another cell value in Excel.ġ. Shade a cell based on another cell value with Conditional Formatting What would you do? This article will show you the method. Supposing you want to shade a cell (says A1) with a certain background color if cell B4 meets the criteria such as has a certain value or the value is greater or less than a specific number. ![]() ![]() How to shade a cell based on another cell value in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |