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