1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Conditional Formatting with another cell?

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?

submitted by /u/Educational-Bass-413
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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