Like I stated in my initial post Excel is not my thing. I looked at the Help
files before I came here. Still having trouble understanding.

--

Regards
Michael Koerner


"steve" wrote in message
...
Michael,

There is a pretty good guide in the Help. Just look up 'conditional
formatting'.

To apply it - go to the Format menu and select Conditional Formatting.

--
sb
"Michael Koerner" wrote in message
...
As I don't work with Excel on a regular basis, this is all new to me.
Where do I
put what? Could I email you the sheet?

--

Regards
Michael Koerner


"Haldun Alay" <haldunalayATyahooDOTcom wrote in message
...
Hi,

You can do that with conditional formatting. Please select your range to
apply the conditions, enter the conditions shown below. and change the
formats for each condition. You need to give a name the range on sheet1.
if
you use directly range area like "Sheet1!A1:C6" excel gives error. in the
code below I use "Data".



First Condition
=VLOOKUP($A2,Data,3,FALSE)="Poor"

Second Condition
=VLOOKUP($A3,Data,3,FALSE)="Good"

Third Condition
=VLOOKUP($A4,Data,3,FALSE)="Fair"

--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"Michael Koerner" , iletide þunu yazdý
...
I have a workbook with 2 active sheets. Sheet One contains the following
headings


ID No. | Courtesy of | Photo Quality ...
001 Poor
002 Good

Sheet 2 is a grid of numbers from 001 - 1000.

How would I have the background colour for the numbered cells in sheet 2
change
to red (poor) yellow (fair) green (good) to match the ID No. and Photo
quality
from sheet 1?

Any assistance, as always, is greatly appreciated
--

Regards
Michael Koerner