Conditional Format

[Guest]

How can I apply a conditional format to a different cell? For example: I
want to format cell B1 based on the value in cell A1. So if the value in A1
was = 1, then I would fill B1 w/ light grey. If A1 were = 2, then I would
not fill B1 at all.

Any ideas?

Thanks.

 

[swatsp0p]

You only mention actions if A1= 1 or 2. What if it is blank or an
other value?

I'll assume A1 must be either 1 or 2. If it is 2, we don't want to d
anything anyway, so in B1, set CF to:

Formula is: A1=1 click Format>Patterns and select Light Gray fo
fill. OK, OK to apply.

When A1=1, B1 should fill lt. gray. Any other value is the defaul
fill. Does this work for you?

Good Luck

Bruc

 

[Guest]

You are correct...If A1 is any other value than one, then do nothing.

However, I cannot get your suggestion to work...

 

[Guest]

1. Highlight Cell B1
2. Select Format->Conditional Formatting
3. Select "Formula Is" (Change from "Cell Value Is")
4. Insert =A1=1 as your formula. Include both equal signs.
5. Select formatting with the "Format..." button

I think the equal signs is what is giving you the problem.

Notice the '=' in front; it is necessary to have both '=' characters.