Highlighting row based on particular value in Excell

By
Dear Colleagues,

Very Frequently I’ve come across this requirement when I’m asked to suggest Excel formatting solution where a user needs to highlight the complete row based on some particular value in another column/cell in the same Excel workbook.

The solution is very simple, this formula applied in “Conditional Formatting” will do the trick……  =INDIRECT("ColumnNo"&ROW())="Value"
Ex:
=INDIRECT("E"&ROW())="Pending"

1.       Go to Conditional Formatting (option),
2.       Select “Use formula” (option),
3.       Enter the above formula with appropriate ColumnNo & Value,

4.       Select the range to which this Formatting should be applied…
And u’re done.


Contact me in-case of further clarification(s).

G.S Virdi
Location: Ghaziabad, Uttar Pradesh, India

Comments

Post a Comment

Please maintain decency of the internet, do not spam.

Popular posts from this blog

Baby Falak, a cursed angel

By
Ten facts about Baby Falak NDTV Correspondent , Updated: January 30, 2012 15:15 IST New Delhi:  A battered two-year-old baby is fighting for her life in the intensive care unit of Delhi's AIIMS hospital. As the nation watches a heart-rending story unfold in shock and horror, here are 10 facts about the child we now know as baby Falak. Who is baby Falak? A two-year-old baby was brought to Delhi's All India Institute of Medical Sciences (AIIMS) on January 18 with severe head injuries, fractured arms and human bite marks all over her. A minor girl who brought her to the hospital reportedly told doctors that the baby had fallen from her bed, but doctors said that claim did not match with the injuries seen on the child's body. The child is fighting for her life ever since in the Intensive Care Unit of the hospital. She has been named Falak, or sky, by the staff looking after her. What is baby Falak suffering from? Doctors monitoring the two-year-old say she is a victi
Read more

Why I wear a Rose Quartz

By
Image
Rose quartz is a type of quartz that exhibits a pale pink to rose red hue. The color is usually considered as due to trace amounts of titanium, iron, or manganese in the massive material. Some types of quartz contain microscopic rutile needles that produce an asterism in transmitted light. Recent X-ray diffraction studies suggest that the color is due to thin microscopic fibers of possibly dumortierite within the massive quartz. [15] In crystal form (rarely found) it is called pink quartz and its color is thought to be caused by trace amounts of phosphate or aluminium . The color in crystals is apparently photosensitive and subject to fading. The first crystals were found in a pegmatite found near Rumford, Maine, US, but most crystals on the market come from Minas Gerais, Brazil. [16]   Source: http://en.wikipedia.org/wiki/Quartz#Rose_quartz   Spiritual and Healing Properties of Rose Quartz: Rose quartz is an excellent heart-healing gemstone . It is a
Read more

Guru Nanak Dev

By
Image
Here are few Pix of Guru Nanak Dev which always caught my attention J               Questioning eyes:         The portrait Below is believed to be drawn by a blind man, obviously the painting below is by someone else:     And… here are my Favs……       This is believed to be the very 1 st of Pictures of Guru Nanak, but I can’t authenticate it.   If u have any other picture which u feel would be good to share, then plz do let me know about it.   PS: All these Pix are taken from the Internet, I don’t have any claim on any of them. GS Virdi  
Read more