Conditional Formatting for a complete ROW

Hi Shadmani,

I don't have access to Excel 2003 but you should be able to highlight the Cells in the Row you want to Format & then add the formatting.

So, can you highlight the Cells & then go to Conditional Formatting to apply your rule?

Let me know how you go.

Not advisable to use Conditional Formatting on an entire row, it could slow your file down. Rather, just use CF on the range you need.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A2="PASS"...format fill GREEN

Assuming you have PASS in A2 - adjust as needed

Not advisable to use Conditional Formatting on an entire row, it could slow your file down. Rather, just use CF on the range you need.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A2="PASS"...format fill GREEN

Assuming you have PASS in A2 - adjust as needed