value selection

[peterod]

Hi all. Relative newbie question

For the purpose of this i will use an example.

I have a table of values as follows.

columns are

value 1 | value 2 | Value 3 | Value 4 |

I want to

highlight the lowest value in each row using conditional formating or similar.

i also want the lowest figure to go into a seperate box on the form for each row (which for the purpose of this example i will call "selected value")

Im trying to make a price comparison database.

Look forward to seeing you guys solution to this

Much thanks n advance.

 

[pbaldy]

The design isn't normalized, but:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857