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

A new kind of "Proud Rapists" of India

By
New trends of killing the girl child By ANI | ANI  – 17 minutes ago Darbhanga, Mar 20 ( ANI ): The U.N. Department of Economic and Social Affairs report indicating that India is not a safe place for the girl child hit the headlines in many newspapers and news channels in the country. Indian society has been known for its preference for the male child. Among the 150 countries surveyed, including countries classified as LDR (Less Developed Regions), India has the highest rate of female child mortality. According to this new data - an Indian girl between the ages of one and five years old is 75 percent more likely to die than an Indian boy, giving the country the worst gender differential in child mortality in the world. For every 56 boys that die in this age group, there are 100 girls who die in India. However, statistically with the biological benefit that girls have over boys for survival at this stage, the standard ratio of child mortality for the rest of the worl
Read more