Thanks,
I tried this in a few of the cells - Cell range for Day 1 is B250-B1000
so I tried in B251, B252, B253 and it worked, but I'm not sure what you
meant by applying it to all other cells.



"SteveG" wrote:


Corben,

You could use conditional formatting. Select the first cell you want
to see if is in your list of criteria (in my example B5). Go to
FormatConditional formatting. Change the Cell value is option to
Formula is. Enter this formula.

=COUNTIF($A:$A,B5)=0

Click on Format, Font and change the text color option to Red. Click
ok and ok. Use the format painter to apply this to all other cells
where you will be pasting in the data. This is where column A is not
one of the columns where you will be pasting the data.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=535094