highlight a row in a table -automated using macro

[Hapr1]

Hello , I have a problem .i want to highlight a complete row ina table . how do I do it ? then I need to make this work in a macro ?

 

[supercharge]

Mission Impossible! there's no way that can be accomplished, not as I know of.
You might want to consider using a listbox or form and mimic them to look as a table.

 

[ghudson]

Your users should never be in the table! There are no events or formats that you can apply to a table. The users should only access the data within a form.

 

[Johnvandamme]

Hello,

Add a field to your table. color : number 1 or 2
Then create a form based on your table
put all fields in a columnar format (use the wizard if you are lazy)
then take the color field and stretch it to the size of the form and put it to back.
Add a conditional formatting: if 1 put in RED for example.

Creative solution...

Good luck !

John