Results 1 to 14 of 14

conditional formatting...

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    8

    conditional formatting...

    Hi all, please could you help me with this problem I am trying to solve.

    I have a spreadsheet with columns headed by date and the rows are payments in.from different people. What I am trying to do is that if a payment of 55 comes in on the 1st of the month the rest of the month gets shaded a different colour. If it is any other amount then it stays it's default colour.
    As this sheet is for a whole year I was hoping I could do this in some way so that I could drag it trough the whole sheet. I can do it if I type it month by month I think.

    I hope this makes sense.

    Thank you in advance for any help you can give.
    Last edited by shinsei jutsu; 01-10-2011 at 09:22 AM.

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