Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Conditional Format ? (Excel 2003)

    Hi

    I have a conditional format problem.

    If Units Sold (column H) is blank then want columns L, N, P, R, T, V and X clear (i.e. not coloured), then if Unit Sold has a value (e.g. 450) then if the above column values are >0 then the box becomes blue or if they are 0 then the box remains clear/not coloured.

    Sorry about the links but I thought the formulas were part of the problem.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Conditional Format ? (Excel 2003)

    Does the pink formatted box do what you want?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format ? (Excel 2003)

    Is this what you want?
    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Conditional Format ? (Excel 2003)

    Hi Legare

    Both yours and Catherine's suggestions work just fine for me.

    Thanks very much to both of you.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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