LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
aristotle
 
Posts: n/a
Default

Make sure the "00000" is within quotes, that's all I can think of.

"bluebean" wrote:


Thanks for that guys - unfortunately when I go in to do that, it changes
all the cells to yellow, regardless of whether or not they end with
00000.....
any ideas why this would be? thanks.


--
bluebean
------------------------------------------------------------------------
bluebean's Profile: http://www.excelforum.com/member.php...o&userid=25951
View this thread: http://www.excelforum.com/showthread...hreadid=393248




 
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
Highlighting text using conditional formatting Greshter Excel Discussion (Misc queries) 2 July 14th 05 03:04 AM
Conditional formatting on named text field Sharon P Excel Discussion (Misc queries) 1 June 21st 05 10:30 PM
How do I apply conditional formatting to a text box barneshere Excel Worksheet Functions 1 May 27th 05 06:26 PM
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM
Conditional formatting of text LeAnne New Users to Excel 7 March 4th 05 02:34 PM


All times are GMT +1. The time now is 12:43 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"