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

2,325 thoughts on “Conditional formatting for entire column

  1. toko online 88

    Everything is very open with a precise description of the challenges. It was really informative. Your website is extremely helpful. Many thanks for sharing!

  2. situs bandarq online

    I like the helpful information you provide in your articles.
    I’ll bookmark your weblog and check again here frequently.
    I am quite certain I’ll learn lots of new stuff right here!
    Good luck for the next!

  3. harga

    Everything is very open with a very clear explanation of the challenges. It was truly informative. Your website is very helpful. Thanks for sharing!

  4. pokerqq

    Wonderful beat ! І wiѕh to apprentice whіⅼe you amed үour website, how could
    i subscrkbe fߋr a weblog site? Ꭲhe ccount helped me a acceptable
    deal. І had been a litte bіt familiar οf tһіs your broadcast provded
    shiny ⅽlear concept

  5. vivoslot net

    I would like to thank you for the efforts you have put in penning this site. I really hope to view the same high-grade content from you later on as well. In truth, your creative writing abilities has encouraged me to get my own, personal blog now 😉

  6. exchange

    Howdy would you mind letting me know which hosting company you’re
    utilizing? I’ve loaded your blog in 3 completely different internet browsers and I must say this blog loads a lot quicker then most.

    Can you recommend a good web hosting provider at a fair price?

    Thank you, I appreciate it!

  7. agen vivoslot

    You made some good points there. I checked on the net to find out more about the issue and found most people will go along with your views on this web site.

  8. vivoslot

    I’m amazed, I must say. Seldom do I come across a blog that’s both equally educative and interesting, and let me tell you, you have hit the nail on the head. The problem is something too few folks are speaking intelligently about. Now i’m very happy I stumbled across this in my hunt for something regarding this.

  9. togel sd

    Hi there, I believe your web site may be having browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine but when opening in I.E., it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, fantastic blog!

Comments are closed.