Posted to microsoft.public.excel.programming

Sean

external usenet poster

Posts: 454

Change Text Colour if Value is in a List Q

How would I change the Text colour of a cell to white (invisible) if
that Value in the cell is listed within a list?

For example I have a range of values in Sheet1 from A5:W30, if any of
these cells is contained within the list that is detailed on Sheet2
A1:A5, then I want to change those values in Sheet1 A5:W30 to White

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
change text colour	aditya	Excel Discussion (Misc queries)	5	June 23rd 09 05:56 PM
Change Text Colour	CT (Oxford, UK)	Excel Discussion (Misc queries)	2	April 12th 09 12:18 PM
How do I change the text colour in a drop down list?	Bluetone101	Excel Discussion (Misc queries)	1	October 29th 07 03:41 PM
change text colour	Jeff	New Users to Excel	3	February 15th 06 05:53 AM
Change Colour OF Text???	James UK23	Excel Discussion (Misc queries)	1	May 19th 05 12:32 AM

All times are GMT +1. The time now is 08:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us