Yes use Conditional Formatting:
I assume that you want A1 background to start white.
Therefore set up two conditions in A1:
=B1="x" and choose fill red
second condition:
=C1="x" and choose fill green
You haven't however stated what you want to occur if B1 & C1 both contain x.
With the above formula conditions if both contain x, then A1 will turn red
Hope this helps
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
