View original (French)

Extend conditional formatting in Excel

Solved
jfda -  
Hello,

In Excel, I want to extend a conditional formatting to an entire column.

Example: If B1 is different from A1, then red.

I want to apply this condition to the entire column B, how can I do that?
When I drag it down, the condition always refers to B1, while I need to increment A2, A3...

Thank you for your help

Configuration: Windows XP / Internet Explorer 6.0

2 answers

  • Votes
  • Date
  • Descending date
  1. pijaku Moderator
    Hello,
    Select the entire column before applying the conditional formatting.
    --
    Best regards,
    -- Every problem has its solution. If there is no solution, where is the problem? --
    1. jfda
      Hello, thank you for this response but apparently, it doesn't work... ???
    2. pijaku Moderator
      yes indeed, this method does not work with just any formula. For example: <>A1 will not work. We need a formula that returns TRUE or FALSE according to the condition to get the expected result. Example: =IF($A1=$B1,"FALSE","TRUE").
      Method:
      - Select the entire column B (by clicking on the header letter B)
      - Format/Conditional Formatting
      - Choose from the dropdown menu: "The formula is:"
      - enter this formula: =IF($B1=$A1,"FALSE","TRUE")
      - click on the format button and choose the cell formatting
      - OK
      - OK
      and... it works!!!