Condional Format using a Formula

[wysbob]

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

[JohnTopley]

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

[Aardigspook]

Hi,

Use Conditional Formatting, with the following formulae:
Red:

=AND(A2="",A3="")

Orange:

=OR(AND(A2="X",A3=""),AND(A2="",A3="X"))

Green:

=AND(A2="X",A3="X")

To do this, select 'Conditional Formatting' from the 'Styles' section of the Home ribbon. Select 'New Rule' and then 'Use a formula to determine which cells to format'. Type one of the formulae above into the box below, format it as required (Red/Orange/Green fill) then repeat for the other two.

Hope that helps.

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.


Edit: this is the same as JohnTopley's post, just more long-winded!

[wysbob]

Thanks for the help exactly what I was needing

[Aardigspook]

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.