Results 1 to 9 of 9

Thread: Conditional Formatting Not Functioning Correctly
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting Not Functioning Correctly

    I've created formulas for my conditional formatting, and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
    The rule is not being followed - any ideas?

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,436
    Post Thanks / Like
    Mentioned
    40 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Quote Originally Posted by mmac723 View Post
    I've created formulas for my , and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
    The rule is not being followed - any ideas?
    You can put the formula you have in the conditional formatting on each sheet and what do you have in apply to
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    May 2019
    Posts
    180
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Quote Originally Posted by mmac723 View Post
    I've created formulas for my conditional formatting, and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
    The rule is not being followed - any ideas?
    it's because your conditions in the new sheet are not in the same place, so your condition field on the new formatting is having no restriction based on what field it's actually pointing to. Manage rules in conditional formatting and choose the one on the sheet your having a problem with, and look at the cells it's referencing

    (either due to having relative references and not pasting the formatting in the same cells on the other sheet, or having absolute references that do not match up on both sheets)
    Last edited by Twollaston; Jun 18th, 2019 at 02:16 PM.

  4. #4
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Quote Originally Posted by DanteAmor View Post
    You can put the formula you have in the conditional formatting on each sheet and what do you have in apply to
    The formula is =$L7="Scheduled on OAP" > Format Green> Applies to: =$A$7:$U$505

    But the cell in Column L is blank, yet it is still turning ever row green.
    Other formatting supersedes it, so if I put in another data point, it will revert to grey or orange, or whathaveyou.
    I just don't want a totally green spreadsheet....

  5. #5
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    I've checked, and the rules apply to to correct cells -
    My issue (which I don't think I made clear) is that the cell is blank, and its still turning green.
    Maybe I'm missing something super simple, but I cant seem to keep the rules in place and have a non-green spreadsheet.

  6. #6
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,667
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    I have always found the Format Painter to be a bit flaky/unpredictable when it comes to Conditional Formatting.
    Your formulas look pretty basic. I would recommend just writing them directly to your other sheets instead of trying to use the Format Painter.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  7. #7
    New Member
    Join Date
    Jun 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Quote Originally Posted by Joe4 View Post
    I have always found the Format Painter to be a bit flaky/unpredictable when it comes to Conditional Formatting.
    Your formulas look pretty basic. I would recommend just writing them directly to your other sheets instead of trying to use the Format Painter.

    I'm going to sound lazy here - but there are 28 conditions and 52 tabs that need application of formatting.
    I'm trying to find an easy fix - it's totally possible to do individually, but I'm dreading it....

  8. #8
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,667
    Post Thanks / Like
    Mentioned
    51 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Try using the Macro Recorder as you do it to one tab, and record the setting of those rules.
    You should then be able to use that code to set it up on all tabs (it may require a little fine tuning, depending on the differences in your sheets - but if there are differences, than the Format Painter probably wouldn't work anyway).
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  9. #9
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,436
    Post Thanks / Like
    Mentioned
    40 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Conditional Formatting Not Functioning Correctly

    Quote Originally Posted by mmac723 View Post
    The formula is =$L7="Scheduled on OAP" > Format Green> Applies to: =$A$7:$U$505

    But the cell in Column L is blank, yet it is still turning ever row green.
    Other formatting supersedes it, so if I put in another data point, it will revert to grey or orange, or whathaveyou.
    I just don't want a totally green spreadsheet....
    I tried your Conditional Formatting and it works. You comment that you have other Conditional Formatting, you could put them to review them together.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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