Are you using Excel 2003 or 2007.

In 2003 you can do this by selecting the status column and assigning
conditional formatting rules for the 3 conditions. Only that column will be
highlighted. In 2007 you should be able to acheive the entire row formatting

If this post helps click Yes
---------------
Jacob Skaria


"Ricardo" wrote:

Hi,

I understand that what I am trying to do is a variation of "Conditional
Formatting", however none of the topics I have read cover what i'm trying to
do.

Step 1: Copy data from a table into a preformatted spreadsheet
Step 2: I would then normally have to colour each row depending on whether I
have received the certification for it. In otherwords "complete" "incomplete"
"partial" etc etc.

What I would like to know is if I can set it so that excel automatically
reads the status column and finds "Complete" it will automatically colour
that entire row "green" (generally about 8 rows across).

ex

1 | Complete | 012345 | etc etc - Would automatically become green once
copied from a database into the spreadsheet.

2 | Incomplete | 012346 | etc etc - Would be red.

Kind Regards,

Ricardo Martinelli