Formating one cell reading date from another.

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
 
B

Bob Phillips

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)
 
G

Gord Dibben

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
 
Top