Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2014, 07:49 AM
thetraininglady thetraininglady is offline Create calendar in Powerpoint 2010 Windows 7 64bit Create calendar in Powerpoint 2010 Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

The green flags simply try to notify you if Excel see's a problem. Excel has noticed that your formulas are not consistent in how they are entered.

I've had a look at the file and from row 6 onwards you have a space in between the cell reference (A5) and the + symbol. Best not to use any spaces in the formulas. So it should read =A5+7 which no spaces in between each part of the formula. So click in cell A4, position your mouse over the bottom right corner of the cell till you see the AutoFill icon which looks like a cross then autofill down the column again to overwrite the entries, repeat for column B, C, D, E, F and G and the green flags should disappear.

Yes if you change the date in cell D2 to 01/01/14 the dates will all update.
I'm about to go offline so will check in tomorrow to see if all was ok.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a windows 8-like scrolling in a powerpoint slide? johan_lilje PowerPoint 0 10-01-2013 07:34 AM
How to create a days countdown in powerpoint? john.kelly11 PowerPoint 3 04-09-2013 09:56 AM
Help! Need VBA solution to create CSV file and export to Google Calendar mister_audioman Excel Programming 0 01-12-2012 01:07 PM
Sync Outlook 2010 Calendar to Sharepoint Calendar paankadu Outlook 0 12-08-2011 08:25 AM
Create calendar in Powerpoint 2010 Create calendar event groegee Outlook 1 12-05-2011 09:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft