Hi, I'm creating a database using excel 2010 for the calibration of tools. The columns I have are "date calibrated" (manually insert a date), and "date due" (I have already put a formula in there which + 365 days to the date calibrated). The problem I am having is that when I drag the formula down the column it automatically puts a date in the rows that have no information yet. Is there a way to hide the formula until new tool information is entered into a row?
I hope someone can help, Thanks, Tom
Hi, I have a database for the calibration of tools. I have created the formulas, which work, to make the due date go GREEN when over 30 days of the due date, YELLOW when within 30 days and RED when on the due date or over the date. Is there a way of pulling the formulas down so when each row has a date entered the due date will change colour. I have tried to pull the formula down but the whole column changes colour when the first date cell changes.
Thanks again, Tom
You can use an IF function in the first cell in which you want the "Date due" to be shown:
where A1 contains the "Date calibrated" value=IF(A1>0,A1+365,"")
Excel 2003 user (and starting to warm to Excel 2007)
edit the conditional formating formula - take out $ infront of row number... in other wprds change $A$1 to $A1 etc...
Tom288,
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks