LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 493
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Document Properties in Excel AlwaysFroosh! Excel Worksheet Functions 3 September 26th 06 07:30 PM
I'd like to use Excel to make changes to an HTML document... Jola Excel Discussion (Misc queries) 2 March 7th 06 02:29 PM
How to I stop displaying documents under Document Recovery Pane Vijay Setting up and Configuration of Excel 1 March 5th 06 02:03 AM
how do you "select locked cells" w/o "select unlocked cells"? princejohnpaulfin Excel Discussion (Misc queries) 3 July 16th 05 03:53 AM
Literally displaying imported cells with and tags [email protected] Excel Discussion (Misc queries) 3 January 13th 05 11:54 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"