Condl formtng of range of cells based on one value

  • Thread starter Thread starter Sue in AZ
  • Start date Start date
S

Sue in AZ

Hello all you Excel gurus,

I searched and found the answer (I thought) to my question, but it's not
working for me. Can someone check my work and advise?

Using Excel 2003
I want to take a rectangular range of cells, say A1:C7 and format it all
based on one possible value of one of the cells, say if cell C7=100%

The answer I found and tried said to select all the cells I'm interested in
(just click and drag to hilight, right?) and conditionally format using the
formula (modified to my example)
=C7=100%

The result is that only the first cell (A1 in my example) turns colors.

Also tried
=$C$7=100%
too, but still no joy. Didn't think that'd make a difference, but I'm not
all-knowing!

Can this work on a rectangular range? If not, is there another way to make
it work?

TIA!
 
Yikes, sorry! The
=$C$7=100%
did indeed work!

My apologies for cluttering the board.

How can I delete my dumb quesiton?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Omit empty cells? 0
Using NULL in shading cells 1
Need a function 1
RANGE EXCEL copy cell that meets criteria in a range 3
Sum contents of multiple cells when the # of multiple cells is unk 5
Range of values 2
Multiple functions 2

Back
Top