Need help: Conditioning "Conditional Formatting" for multiple cells

E

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
 
A

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
 
Top