ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Displaying select cells in HTML document (https://www.excelbanter.com/excel-discussion-misc-queries/145839-displaying-select-cells-html-document.html)

ALEX

Displaying select cells in HTML document
 
I have an HTML page with a color coded table, and I have an Excel spreadsheet
that has a row of cells with "Yes" and "No" in them.

Say B5 contains "Yes", then I would like a certain cell of my HTML table to
have a blue background. If B5 says "No", then I would like the background to
be red.

I've found lots of stuff on how to make an entire Excel spreadsheet into
HTML format. That's not what I want to do. I just need my HTML document to
read a certain cell in an Excel spreadsheet, and depending on what it reads,
pick a background color for one of its <td tags.

I have no idea how this would be done, but if it's not possible, what about
simply copying whats in an Excel cell and displaying it within the <td </td
tags of the HTML document?

Any help would be greatly appreciated


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com