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