Programmer puzzle solving

    最新消息：Welcome to the puzzle paradise for programmers! Here, a well-designed puzzle awaits you. From code logic puzzles to algorithmic challenges, each level is closely centered on the programmer's expertise and skills. Whether you're a novice programmer or an experienced tech guru, you'll find your own challenges on this site. In the process of solving puzzles, you can not only exercise your thinking skills, but also deepen your understanding and application of programming knowledge. Come to start this puzzle journey full of wisdom and challenges, with many programmers to compete with each other and show your programming wisdom! Translated with DeepL.com (free version)
    你的位置： HOME>matter>excel - Conditional formatting not working correctly - Stack Overflow

    excel - Conditional formatting not working correctly - Stack Overflow

    matteradmin3PV0评论

    I have a problem in excel with conditional formatting.

    I created a rule for the column D6:D107

    Conditional formatting for area:

    =$D$6:$D$107

    Rule:

    =AND(E6<>"x";F6<>"x";G6<>"x";H6<>"x";I6<>"x")

    When I set x to E6 then the conditional formatting take place in E6 as well. When I set x to G6 then the conditional formatting will not be set in G6.

    I tried to remove $ from area

    =D6:D107

    but during saving the rule, excel is setting it back automatically to absolut area

    =$D$6:$D$107

    What can I do that the conditional formatting only takes place in area D6:D107? How can I force excel to use only relativ area?

    Articles related to this article

    Post a comment

    comment list (0)

    1. No comments so far