If ...then

[Guest]

I am trying to make it so when the results of an equation are positive the
results become one color, and when the results are negative, then the results
are another color.

I would also like to do that if on another spread sheet the date is before
or after a specific date.

How can I do that?

-sara-

 

[PCLIVE]

You need to use Conditional Formatting. From the menu items, select
Format-Conditional Formatting. Choose "Cell Value Is" "less than". Enter
0. then change the format as needed. Add a condition and do the opposite
for positive numbers.

I'm not sure there is a way to do the other part you want without using VBA.