Conditional formatting for entire column

Hi I want to apply conditional formatting to entire column.

Here is my requirement:

 

I want to highlight a cell if it has a value (date to be specific) greater than its adjacent cell.

For e.g.: Lets say B2 has greater date than A2, then B2 should get highlighted in red. If B2 has equal value to A2 then B2 should get highlighted to green and if B2 has lesser value that A2 then B2 should get highlighted in yellow.

I want to apply this rule to entire B column like if B3 > A3 then B3 should be red. B4>A4 then B4 should be red and so on.

By: Prataik Kanade

One thought on “Conditional formatting for entire column

  1. Kimberley Price

    Hi Prataik,

    I don’t have the answer to highlight the Cell you are speaking of just yet, however if you insert another column and use this code;

    =IFS(B1>A1,”R”,B1<A1,"Y",B1=A1,"G")

    Then do your conditional formatting in Column C to highlight the R/G/Y, this would be a good workaround for now! 🙂

    -Kim

Leave a Reply

Your email address will not be published. Required fields are marked *