LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
langba
 
Posts: n/a
Default Conditional format from a list of numbers


I have a very small field of results but a large list of numbers that
are "good" numbers. They are not sequential. I'd like to have any one
of these few numbers to highlight if they equal any of the many numbers
from the large list. Conditional format does not allow me to select an
array but I remember seeing somebody do something like this without a
macro. I don't know much about macros.


--
langba
------------------------------------------------------------------------
langba's Profile: http://www.excelforum.com/member.php...fo&userid=4144
View this thread: http://www.excelforum.com/showthread...hreadid=530664

 
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
How to format cells to recognize numbers like 1.1.1? GStrawley Excel Discussion (Misc queries) 2 January 27th 06 06:54 PM
Conditional Format Not Working KMH Excel Discussion (Misc queries) 0 December 22nd 05 05:32 PM
Conditional Format for Numbers Tyson Excel Discussion (Misc queries) 3 June 28th 05 02:08 AM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Copying a conditional format Meaux Excel Worksheet Functions 2 November 29th 04 10:19 AM


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