Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Highlighting cells depending on val
Name: chistin Date: January 17, 2009 at 14:13:53 Pacific OS: Windows XP Home SP1 CPU/Ram: T5600/1 GB Product: Dell / Xpsm1210 Subcategory: Microsoft Office
Comment:
Hi, I'm having some trouble with conditional formatting in Excel (i'm using windows vista). I want Excel to highlight a cell if the value of that cell equals another one eg. if cell A1 is less than 6 months old, then highlight cell B1 OR if cell A1 is between 6 months and 2 years old, highlight cell C1, etc. I would appreciate help on this, thanks!
Summary: I was wondering if it was possible to change a cells value depending on the date set on your computer. If not is there any other software that you know of that can do this aswell as the basic stuff ex...
Summary: Hi, There are three main things to know about Dates and Times in Excel 1. Excel holds dates and times as a single decimal number, with the decimal part as the time from 0 to almost 1. 0.5 is 12 noon ,...
0 
