Using Conditional Formatting: If cells contain, then color to?

**davelarue** · 01-27-2011, 05:58 AM

Could someone explain to me how i should do this, step by step using Excel 2007:

Logic:
Users will enter '1' in column A and B, and a status color will display in column C:
- If user entered '1' in both A and B, then C color should be set to 'Green'
- If user entered '1' in either A or B, then C color should be set to 'Orange'
- If user didn't enter '1' in either field, then C color should be set to 'red'

See attached example

Thanks guys,
davelarue

**NickyC** · 01-27-2011, 06:16 AM

Click conditional formatting > manage rules > new rule and select "use a formula to determine which cells to format" then add your rules eg

=OR(A1=1,B1=1)

and set the condition to orange

Don't use fixed cell reference (e.g. = $A$1) or the formula will not copy sucessfully

the attached may help

**davelarue** · 01-27-2011, 06:58 AM

Perfect. Thank you very much!

**cnewsom** · 05-01-2012, 04:38 PM

So how do you then apply that rule to more than one cell at once? For example, I want to set up a rule that says if a cell in colum D=0, then color the cooresponding cell in column E red.

To make things more complicated, I also need a rule the says If the number in B is less than the corresonding nuber in A then color C red. Then i want to apply that rule to the entire C column with cooresponding A and B values.

**arlu1201** · 05-02-2012, 02:22 AM

Cnewsom,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.