View original (French)

Extend conditional formatting in Excel

Solved
jfda -  
 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 réponses

Réponse 1 / 2
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 771
 
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? --
2
jfda
 
Hello, thank you for this response but apparently, it doesn't work... ???
0
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 771
 
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!!!
0