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

25 thoughts 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

  2. thiet ke noel

    I will right away clutch your rss as I can at to find your e-mail subscription link or e-newsletter service. Do you have any? Please permit me recognise so that I could subscribe. Thanks.

  3. nfl jerseys

    Nice post. I learn one thing more difficult on completely different blogs everyday. It would all the time be stimulating to read content material from different writers and follow somewhat something from their store. I抎 prefer to use some with the content material on my blog whether or not you don抰 mind. Natually I抣l offer you a link on your net blog. Thanks for sharing.

  4. download now

    Usually I do not read article on blogs, however I wish to say that this write-up very pressured me to try and do so! Your writing style has been amazed me. Thank you, quite great article.

Leave a Reply

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