formatting a cell

[frank]

is there any way to format a cell but having it depend on
the value or entry in another cell?

 

[Bob Phillips]

Frank,

Sounds like conditional formatting. For instance in B1, goto conditional
formatting, and use Condition1 of FormulaIs, and a formula of say =A1=27,
then format (via the format button) as required. Just use an appropriate
formula.

 

[frank]

-----Original Message-----
Frank,

Sounds like conditional formatting. For instance in B1, goto conditional
formatting, and use Condition1 of FormulaIs, and a formula of say =A1=27,
then format (via the format button) as required. Just use an appropriate
formula.

--

HTH

Bob Phillips




.
What is the format needs to depend on whether there is

data entered in another cell or it's blank

 

[Bob Phillips]

Frank,

If there is data or its empty? That covers everything doesn't it.

What cell is it? What do you want top format as if data? What if empty?

 

[frank]

-----Original Message-----
Frank,

If there is data or its empty? That covers everything doesn't it.

What cell is it? What do you want top format as if data? What if empty?

--

HTH

Bob Phillips




.
Thanks for your help. I would really want A1 to be

shaded if B1 is not blank.

 

[Bob Phillips]

Frank,

Select A1
Goto menu Format>Conditional Formatting
Change Condition1 to ForumulaIs
Add a formula of =B1<>""
Click the Format button
Select the Pattern tab
Choose your colour
Exit