Conditional Formatting (2 Parameters)

[cmtgrame]

_________________Shoes
White
Green
Blue
Black_____________100
Orange

Is there a way to highlight the 100 amount automatically based off of Black+Shoes? If I can't Highlight it, can I change the 100 to 0 automatically?


intersection example.xlsx

[ben_hensel]

Yeah, "format with a formula" and then this:

Please Login or Register  to view this content.

So you use an objective row reference + subjective column reference for the shoes half, and vice versa for the color half, and only when both are true will it highlight.

[ranman256]

Try this

Please Login or Register  to view this content.