Excel 2007 Conditional Formatting using different colors
 

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?

Excel 2007 Conditional Formatting using different colors
 

See http://www.contextures.com/xlCondFormat01.html

--
__________________________________
HTH

Bob

"tweets75" wrote in message
...
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?

Excel 2007 Conditional Formatting using different colors
 

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

"tweets75" wrote:

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?