After hitting CTRL + Enter the cells will still be selected.

Click on the color picker icon and select a color.


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 13:22:02 -0800, da wrote:

Hi
thanks for your suggestion; however, I have one more follow up questions.
Once I copy the data from above cell, I want to highlight the copied data in
yellow or any other color. How can I do it?
thanks

"RagDyer" wrote:

Select Column A,
Hit <F5
Click "Special",
Click "Blanks",
Then <OK

Type the equal ( = ) sign,
Hit the <UP Arrow,
Hit <Ctrl <Enter,

And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"NoBooks" wrote in message
...
Hi Everyone,

I am trying to copy some info from the cell above into the cell beneath.
However, the cells change and there are thousands, so I can't do a regular
copy and paste or fill by hand. For instance, I have employee numbers in
A1
to A100. There are ratings for these employees in the B column. Say there
are
5 ratings for each employee, but only the first score has an employee
number
attached to it. Therefore there are four blank fields for every filled
field
in A.

Basically, what I was trying to do was do a vlook-up from a different
workbook, but I ran into problems when I couldn't pull all the employees'
scores because there were blanks in my A column. I figured the easiest way
around this was to copy all the employee numbers into the cells beneath,
but
if anyone has an easier way of doing this, it would be much appreciated.

Thank you so much!

A