Formating one cell reading date from another.

  • Thread starter Thread starter Jay3253
  • Start date Start date
J

Jay3253

How do I format a cell to look at another cell for its formating.
have a cell where I input data, and a formula cell, but if the value i
negative in the formula cell I would like to see that in the input cel
by a change of color so it can be changed to make the formula cel
positive. How do I do this, I don't know anything about macros and a
learing this as I go. Please help.
Jaso
 
Jay,

Use conditional formatting. In the input cell, use a condition of FormulaIs,
and a formula of =M1<0 (assuming M1 is the formatting cell), and click the
format button to set the pattern colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Jason

Assuming the data input cell is A1 and B1 is formula cell.

Select A1. Format>Conditional Formatting>Formula is

=B1<0

Pick a color from Format>Patterns and OK.

Gord Dibben Excel MVP
 
Back
Top