Conditional Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You are correct...If A1 is any other value than one, then do nothing.

However, I cannot get your suggestion to work...
 
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.
 
Back
Top