Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Format formula (Excel 2003 SP2)

    Hi all!
    Attached is a sample workbook. Can someone please tell me how to create a formula for use by Conditional Formatting that would give the same results as the sample? I do not want to use VBA to accomplish it.
    If a cell is Blank or contains one of two preset numbers, the background is Pale Blue. Anything else would cause background to be Red.

    Thanks a Heap!
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Format formula (Excel 2003 SP2)

    Here are 2 ways:

    1) select F10:F18 and color them all blue
    format - conditional formatting -
    Formula is:
    =AND(NOT(ISBLANK(F10)),F10<>$C$3,F10<>$C$4)
    [Format} Patterns tab
    Choose Red
    [ok][ok]

    2) select F10:F18 and color them all Red
    format - conditional formatting -
    Formula is:
    =OR(ISBLANK(F10),F10=$C$3,F10=$C$4)
    [Format} Patterns tab
    Choose Blue
    [ok][ok]

    Steve

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format formula (Excel 2003 SP2)

    Steve,

    Thanks! I knew I had seen something like this before, but I am not very good at finding what I need when searching (I did try).

    Thanks again,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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