Posted to microsoft.public.excel.programming

Michael[_20_] Michael[_20_] is offline

external usenet poster

Posts: 15

Color Cell if range values

I have a range of cells (a2:a1677) which I will call
tempdb. I have another range of cells (j2:j851) which I
will call tempdb2. I would to scan each individual cell
in tempdb (a2,a3,..a1677) with the range of values in
tempdb2, if the value is found to match the current cell
value in tempdb then color the cell red and move to the
next cell.

Thank You,

Michael

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Backgroud color for 1 cell based on a range of cells values	schmill	Excel Discussion (Misc queries)	3	July 29th 09 02:18 AM
Find Values in Range Then Color	Cue	Excel Discussion (Misc queries)	2	October 13th 08 01:58 PM
Format cell color based on multiple cell values	Zenaida	Excel Discussion (Misc queries)	1	May 10th 06 07:31 PM
Color Cell if range values	Anders S	Excel Programming	0	November 17th 03 09:47 PM

All times are GMT +1. The time now is 04:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us