APPLY CONDITIONAL FORMATTING TO A ROW IN EXCEL
 

I NEED TO APPLY FORMATTING TO AN ENTIRE ROW WHEN ONE CELL IN THE ROW MEETS A
CRITERIA

APPLY CONDITIONAL FORMATTING TO A ROW IN EXCEL
 

Hi Gayathry

You can do this by using the following. I shall try to apply the format if
A1 = 50.

Select the entire row. Go to conditional formatting In the dropdown use
Formula is and put in this formula =$A2=50. Then Select the format and click
OK. If A1 = 50 the format would apply for the entire row and vice versa.

I hope the said solves your problem
Regards
Raj



"GAYATHRY" wrote:

I NEED TO APPLY FORMATTING TO AN ENTIRE ROW WHEN ONE CELL IN THE ROW MEETS A
CRITERIA