Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Clearing Colors Except Conditional Formatting (2007)

    I have set the conditional formatting in A2:J12 where the values in col E are >=60.

    I want to clear the color on the worksheet that does not form part of conditional formatting. I have tried using the fill color & fontt color, but to no avail. It would be appreciated if you could assist

    Regards

    Howard
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clearing Colors Except Conditional Formatting (2007)

    From the Menu bar pull down View | Normal.
    Regards
    Don

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Re: Clearing Colors Except Conditional Formatting (2007)

    Hi Don

    Thanks for the help. I knew it would be something simple, but I was baffled

    Regards

    Howard

Posting Permissions

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