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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Getting a Cell Value into a Macro! 2
Split hours and minutes in two different cells 4
If Tuesday subtract 4 (Formulas) 3
Conditional formatting in Excel 2010 2
Conditional formate 2
conditional format 4
Question about conditional formatting of zeros in Excel 0

Back
Top