Hi everyone,

Say I have the details below in a worksheet. Under Status, I applied conditional formatting whereas Closed will have a background color of blue. This works perfectly fine.

My question is - Is there a way to apply conditional formatting to an entire row? Say, I have Closed as status, entire row 2 will have a background color of blue.

A B C
1 Name Status Client
2 Stephen Closed Summit
3 Robert New Mini Stop

Also, Is there a way to assign short cut keys in Excel similar to MS Word? say, I need to do paste special. Instead of going to edit>paste>special.

I am using 2003 version.

Thanks in advance!

Maiyk