+ Reply to Thread
Results 1 to 3 of 3

coloring specific cells using a formula - Excel Mobile

  1. #1
    Registered User
    Join Date
    11-26-2007
    Posts
    40

    coloring specific cells using a formula - Excel Mobile

    On my pocket PC, I have this spreadsheet that automatically calculates the calories I've consumed in the day.
    http://img205.imageshack.us/img205/8616/calgh6.jpg

    I think I can do this with conditional formatting, but my pocket PC has Excel Mobile which does not support conditional formatting.

    It would be nice to have a formula that says something like, if cell A7 is equal to the cell above it to turn A7, B7 and C7 a certain color. If it is not equal to the cell above it, to turn A7, B7 and C7 a different color. It would be easier for me to see different days if they were alternating between two colors.

    In the picture (link) I posted above, I manually colored the cells... the screenshot is also from regular Excel and not Excel Mobile.

    Hmm... now that I think about it, if there is a formula in every cell in column A to do this, how would I type the date into column A?

    If anyone knows how to do this on Excel Mobile, your help would be gratiously accepted.

  2. #2
    Registered User
    Join Date
    11-26-2007
    Posts
    40
    Maybe there is not a way to do this?

    Here is a bump.

  3. #3
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Excel Mobile

    If Excel Mobile lacks both conditional formatting and VBA, if find it hard to believe it can be done in any other way. Those are normally the two ways trigger a change in cell color.
    //Ola

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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