formatting a cell

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

is there any way to format a cell but having it depend on
the value or entry in another cell?
 
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.
 
-----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
Click to expand...
data entered in another cell or it's blank
 
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?
 
-----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
Click to expand...
shaded if B1 is not blank.
 
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
 
Back
Top