Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If ...then
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- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If ...then
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. "srinehart" wrote in message ... 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- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|