Search code examples
excelconditional-formatting

Conditional Formatting for rows

How do you drag the conditional formatting across the row? For example I have color red for not equal to and green for equal to, but how can you apply the conditional formatting across the row "Due" for the other dates? enter image description here

Solution

  • Your conditional formatting rules seem to be wrong.

    That should do it:

    1. Erase your current "Conditional formatting" rules.
    2. Select the desired cells in row 10, starting from F10.
    3. Click Conditional formatting / New rule / Formula.
    4. Enter =F$10=F$11, click "format" and choose green fill color. Confirm with "OK" twice.
    5. Repeat step 2 and 3.
    6. Enter =F$10<>F$11, click "format" and choose red fill color. Confirm with "OK" twice.

    Note: The formula is always based on the active cell (the one you choose first in your selection, here F10).