Need help: Conditioning "Conditional Formatting" for multiple cells

[eweiner]

I have to charts that I am trying to compare. The top one is blank and
I will enter in hours people have worked on a project. The bottom one
has the hours allocated to that person for that particular phase. They
are 5 columns by 12 rows.

I set a conditional format in place to say, if the number I enter in
the top sheet is larger than the corresponding number in bottom sheet,
make it red (so that I can know people are charging more hours than
they are allocated.

I don't know how to set conditional formatting for this large range of
cells, short of setting them up, one at a time.

Any help would be appreciated-

~Eric

 

[Anne Troy]

Select them all. Set up a formula as though you were only using the FIRST
cell you selected, and it should work just fine. If I conditionally format
C3 through C20, and I want C3 to be red if it's greater than B3, I would use
value is >B3. It will automatically make it B4, B5, etc...in the other cells
I've selected. I hope this makes sense.
************
Anne Troy
www.OfficeArticles.com

 

[David McRitchie]

Formatting cells individually is something I'd normally strongly
recommend against, but "Format Painter" (icon) works on both
normal cell formats and on Conditional cell formats. You might
give that a try. Also available as a keyword shortcut.
http://www.mvps.org/dmcritchie/excel/shortx2k.htm