•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting with another cell?
Our take
Conditional formatting can significantly enhance your spreadsheet by visually representing data based on specific criteria. In this scenario, you want to change the fill color of Cell A based on its value relative to 10% and the value in Cell B. To achieve this, you can use custom formulas in the conditional formatting rules. This approach allows you to create dynamic visual cues that help you quickly assess the data at a glance. Let’s explore how to set up these conditions effectively.
Hi everyone!
I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them.
For example,
If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red.
How would I go about doing this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#Conditional Formatting#Cell A#Cell B#< 10%#> 10%#fill#green#red#value#condition#change#example#depending