CODEWITHSUNDEEP
excel-formulaconditional-formatting
Matthew Olson
Matthew Olson

Reputation: 13

Excel 3-Color Scale Conditional Formatting with Formula

I am trying to have a cell color to one of three colors if a formula is returned as 'True' using the Conditional Formatting 3-Color Scale. is this possible?

Red = AND($C$22>0,$C$20>$C$25)

Yellow = AND($C$22>0,$C$20<=$C$25)

Green = C22<0

Image starts at cell 19, listed at right

Image starts at cell 19, listed at right

Upvotes: 0

Views: 4594

Answers (1)

Regiz
Regiz

Reputation: 467

yes it's possible through Use a formula condition....

Way to apply the formula conditional format :

Home => Conditional Formatting => Manage Rules => New Rule => Use a formula to determine...

Apply your formulas to get exact result as you liked.

here is the sample snap that i have tried.

enter image description here

enter image description here

Upvotes: 0

Related Questions