Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Row Conditional Formatting (2002)

    I have selected j49:x108 and selected format, conditional format. I select formula is $t49<0 and apply a format. I have values in column t that are less than 0 but no formatting is applied. When I go and look at the formatting that is applied to t55 , for example, it still states $t49.

    How do I fix?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Row Conditional Formatting (2002)

    The formula box should contain =$T49<0, not ="$t49<0"

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Row Conditional Formatting (2002)

    Perfect. Got it to work. Is it possible to - in mass - apply this same formatting to 15 other worksheets simultaneously?

    Thanks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Row Conditional Formatting (2002)

    If you select a series of worksheets (by clicking on the first sheet tab, and Shift+clicking on the last sheet tab, or by Ctrl+clicking individual sheet tabs), then select a range, you can specify conditional formatting for that range in all selected sheets.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Row Conditional Formatting (2002)

    I think, if you have already formatted one worksheet, you can select that area, and click on the Format Painter, then select all worksheets as Hans suggested, and click once where the upper left corner begins it will provide the conditional formatting.

Posting Permissions

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