Excel 2007 Conditional Formatting using different colors

  • Thread starter Thread starter tweets75
  • Start date Start date
T

tweets75

I need to have A1 highlighted red if B1 has an x in it, and A1 highlighted
green if C1 has an x in it. Can this be done?
 
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
 
Back
Top