Results 1 to 9 of 9

Unable to calculate highlighted cells.

Threaded View

Mr Optimistic Unable to calculate... 01-13-2012, 04:42 PM
zbor Re: !!!!!!!?????? Urgent help... 01-13-2012, 04:43 PM
Mr Optimistic Re: Unable to calculate... 01-13-2012, 05:11 PM
martindwilson Re: Unable to calculate... 01-13-2012, 05:18 PM
Mr Optimistic Re: Unable to calculate... 01-13-2012, 05:24 PM
martindwilson Re: Unable to calculate... 01-14-2012, 05:25 AM
zbor Re: Unable to calculate... 01-14-2012, 06:00 AM
WHER Re: Unable to calculate... 01-14-2012, 07:38 AM
martindwilson Re: Unable to calculate... 01-14-2012, 08:06 AM
  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    UK North West
    MS-Off Ver
    Excel 2003
    Posts
    3

    Unable to calculate highlighted cells.

    Can anyone help and excel idiot???

    Please if you are able and willing to shine a light then do so in easy speak haha no technical blurb as I am not too clever with excel only know the basic when it comes to spread sheet design.
    My problem is that I have recently designed a spread sheet with the full 2012 year on it. On this calendar is my shift pattern for each individual month. Every shift involves two travel days (there and back) so on the spread sheet I have highlighted my shift pattern in grey and the each time I have a travel day that cell is coloured green. Is it possible to somehow have the excel mega brain calculate only cells highlighted green and then another calc to count grey cells? Make sense????
    I know how to do calculations within the cell by doing = and then the cells I want to calculate but never highlighted cells only!
    Please help,
    Also I'm on 2010 MS Office

    Cheers
    Last edited by Mr Optimistic; 01-13-2012 at 04:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1