•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
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