Condional Format using a Formula

Hi All, I am developing a spreadsheet that tracks whether a person has completed certain tasks.

Spreadsheet I have is as follows:

Cell A1 will be coded to change colour dependant on cells A2 and A3

If A2 and A3 are blank then A1 will be RED

If A2 contains an "X" and A3 is blank then A1 will be ORANGE- or - If A2 is Blank and A3 contains an "X" then A1 will be ORANGE

If both A2 and A3 contains "X"'s the A1 will become GREEN

Any advice will be appreciated

Thanks
Sandy

using Conditional formatting

Select A1 and then enter these 3 new rules with "Use a formula ...." option

for 1. =AND(A2="",A3="") Set FILL to RED

for 2: =OR(AND(A2="",A3="x"),AND(A2="x",A3="")) set FILL to orange

For 3: =AND(A2="x",A3="x") set FILL to GREEN

Thanks for the help exactly what I was needing

You're welcome, glad we could help.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.