Excel Magic Trick 424: Conditional Formatting For Dynamic Range

Download Files:
people.highlin...
See how to conditionally format a range of cells by selecting items from a drop down list. The dynamic range will be formatted using a TRUE FALSE formula that uses AND, MATCH and COLUMNS functions.

[@muhammadnauman1454]

great, though its old vid , but fortunately found what i was looking for

[@excelisfun]

Glad the video helped, Muhammad!!! Thanks for your support with your comment and thumbs ups : ) This vid was made 10 years ago, I have 1000s of newer Excel tips if you would like: ua-cam.com/users/excelisfun

[@Gilllionaire]

Thank you !

[@HumanityMatters85]

I am using this formula in conditional formatting in office 2019 version
=SUM(B$3:INDEX(B$3:B3,ROWS(B$3:B3)-1))

[@rajeshsingh-cy8ux]

please clear to me that why you add columns($b12:b12)

[@edgarrg1899]

It is counting how many columns are inside this range. Since $B12 is a fixed column, the formula will be counting 1 column inside the range ($B12:B12), but if i copy and paste the formula 1 column to the right, then it will change to ($B12:C12) and that makes 2 columns... think of it as a dynamic column counter. It will increase by 1 column each time you move the formula. Past 3 returns false because march is the 3rd column. Hope this helps.