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- |
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- |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com