+ Reply to Thread
Results 1 to 2 of 2

Thread: Conditional Formatting

  1. #1
    mds310 via OfficeKB.com
    Guest

    Conditional Formatting

    I'm hoping someone will be able to assist. I have a spreadsheet that tracks
    hours. I need to be able to quickly identify if I'm close to or have reached
    a certain number. Was hoping for a conditional formula that will change the
    color and or font of the value once it reaches my pre-determined number.

    Thanks!
    Monica

  2. #2
    Bob Phillips
    Guest

    Re: Conditional Formatting

    Just use CF with a greater than value. Set that value to your threshold and
    set a pattern colour.

    --
    HTH

    Bob Phillips

    "mds310 via OfficeKB.com" <u14855@uwe> wrote in message
    news:55c823bdb4b96@uwe...
    > I'm hoping someone will be able to assist. I have a spreadsheet that

    tracks
    > hours. I need to be able to quickly identify if I'm close to or have

    reached
    > a certain number. Was hoping for a conditional formula that will change

    the
    > color and or font of the value once it reaches my pre-determined number.
    >
    > Thanks!
    > Monica




+ 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.2.0