Michael,

Glad to hear that you got it to work.
Conditional Formatting is tricky the first time through. Especially if you
are using formulas as the condition.

Keep us posted on your progress!

--
sb
"Michael Koerner" wrote in message
...
Steve;

I really appreciate your help. I have got it to work if I have everything
on one
sheet. I had to change the formula a little. I will get around to trying
your
method. I'll try and make what I am doing a little clearer

Sheet 1 Column 1 is numbered from 001 to 500 because I have a header row.
#001
is in A2, #002 is in A3 and so on. In the adjacent column D* I can have
the
value Good, Fair, Poor.

Off to the right I have a set of rows and columns pre numbered

H2 I2 J2..... AA2
001,002,003,....020
021,022.023,.....040 up to 500

My formula in cell H2 with everything on the main sheet looks like this

First Condition
=VLOOKUP($A2,Data,4,FALSE)="Poor" The colour is red

Second Condition
=VLOOKUP($A2,Data,4,FALSE)="Good" The colour is green

Third Condition
=VLOOKUP($A2,Data,4,FALSE)="Fair" The colour yellow

Now, I can leave it all on one sheet. But would like to see if I can get
it to
work from 2 sheets, because I am stubborn, also easier for printing
purposes
<g.



--

Regards
Michael Koerner


"steve" wrote in message
...
Michael,

OK! Let's walk through this.

These are the formulas Haldun supplied

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

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

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


Now with this email opened... so you can come back and copy each
formula.


Go to Excel and select sheet 1.
Select your data range. (from you initial post this should be A1:C1000)
Go to the Insert menu and select Name and select Define.
Enter 'Data' (without the apostrophies) in the top box and click OK

Now select sheet 2.
Select the column that you want to have the format.
(click the D if you want column D)
Go to the 'Format menu and select 'Conditional Formatting'
A dialog box will open and you should see
'Condition 1 with a box under it with 'Cell Value Is'
Click on the (tiny) arrow (just to the right) and select
'Formula Is'
Go back to this email and copy the first formula and paste it into the box
(that is immediately to the right of 'Formula Is'
Click the 'Format' button and select and change Font, Border, Patterns
to your liking. For background color just go to Patterns. Select the
color for this condition and click OK.

Now you should be back to the dialog box.
Click the 'Add' button and you should see 'Condition 2'
Repeat the above process for the second condition.

And repeat again for the third condition.

Post back with your progress.
--
sb
"Michael Koerner" wrote in message
...
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