Forum Discussion
Solved
How to change the colour of a cell based on another value
Hi Everyone, Happy New Year! Looking for some help please. I have already applied conditional formatting to this spreadsheet to highlight improvement (green) or decline (red) in figures. Howeve...
Visit This article: https://techcommunity.microsoft.com/t5/excel/i-need-to-change-the-color-of-all-cells-in-a-row-based-on-the/m-p/3951857#M207727
To change the color of a cell based on another value in Excel, you can use conditional formatting. Select the target cell, go to the "Home" tab, choose "Conditional Formatting," and then select "New Rule." Pick "Format cells that contain" in the rule type, set your condition (e.g., equal to, greater than), and choose the formatting options, including the fill color. This way, the cell color will automatically change based on the specified condition in the adjacent cell, making data visualization and analysis more intuitive.
Also visit https://getdressedshop.com/
Thank you, this is what I have applied to the remaining cells. However, my knowledge of formulas is rather limited so I am a little stuck beyond this. The above reply is comprehensive though. Thank you