Color Cells in Row with Matching Values

[Diggsy]

Hello,
I have a table that has many rows. Each row has many columns with a Name in
each cell. The background of the table has no color. I was wondering is there
a way to make the background of a cell a certain color if it matches another
cell in the same row.
For instance

Bob Jones Steve Smith Bob Jones

If the above was the contents of a row. I would like the cells with Bob
Jones have a certain background color because they match. Any Suggestions.

 

[Kathleen Anderson [MVP - FrontPage]]

How is this table getting created? By you manually or is the results of a
database query?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Diggsy]

Its actually from a Access database crosstab query that I export to a html
with a macro(the export macro from Access). It looks great. I just wonder if
I can do something at the query level or maybe insert code into source code
of the page itself. I would prefer to have it in the query itself because I
update weekly. This would save time from physically inserting the code.
However, I will do that if thats my only option.
Thanks,

Chris

 

[Stefan B Rusynko]

Post your qry sql string w/ the field names that creates the html table row




| Its actually from a Access database crosstab query that I export to a html
| with a macro(the export macro from Access). It looks great. I just wonder if
| I can do something at the query level or maybe insert code into source code
| of the page itself. I would prefer to have it in the query itself because I
| update weekly. This would save time from physically inserting the code.
| However, I will do that if thats my only option.
| Thanks,
|
| Chris
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > How is this table getting created? By you manually or is the results of a
| > database query?
| >
| > --
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| > blog: http://msmvps.com/spiderwebwoman/category/321.aspx
| >
| >
| >
| > | > > Hello,
| > > I have a table that has many rows. Each row has many columns with a Name
| > > in
| > > each cell. The background of the table has no color. I was wondering is
| > > there
| > > a way to make the background of a cell a certain color if it matches
| > > another
| > > cell in the same row.
| > > For instance
| > >
| > > Bob Jones Steve Smith Bob Jones
| > >
| > > If the above was the contents of a row. I would like the cells with Bob
| > > Jones have a certain background color because they match. Any Suggestions.
| >
| >
| >

 

[Diggsy]

Stefan,
Below is the SQL View of the Access crosstab query.
TRANSFORM Max(Driver.DriverId) AS MaxOfDriverId
SELECT Picks.Name
FROM Driver INNER JOIN (Picks INNER JOIN Finish ON Picks.Car = Finish.Car)
ON Driver.DriverId = Finish.DriverId
GROUP BY Picks.Name
PIVOT Picks.RaceNo;

Thanks for your help.
Sincerely,

Chris