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.![]()
Bookmarks