Ok so here's my problem.
I would like cell A1 to turn blue if a condition is fulfilled on a webpage. The condition is that it fills blue if the words 'No news available' are NOT present on the webpage.
The webpage is below.
http://www.londonstockexchange.com/e...&preDate=Today
IF the words are present I would like the Cell A1 to remain yellow.
How could i go about doing this? I assume there must be some sort of either VBA code needed or some very clever If function code.
Thanks
All help is much appreciated
Bookmarks