Cell shading based on conditions

  • Thread starter Thread starter Brad1982
  • Start date Start date
B

Brad1982

My apologies I forgot change b1 to c4 in the formula, it works now :)

I would like this shading to work for each row individually, is ther
an easy way to format all the rows at once while remaining independen
of eachother.

My data is over 80 names with corresponding numbers.

Names are in cells A4:A152 While their corresponding numbers range fro
C4:Q4

A4.........................J4.......................Q4
Joe.........................3......................45
A152.....................j152....................Q152
Bob.......................6.........................63

the formula that worked for the individual row was: =C4=MAX($B$4:$Q$4)

Thanks for your hel
 
Select C4 through Q(whatever)
and with C4 the activecell, use this formula:

=C4=MAX($C4:$Q4)

(I dropped a couple of $ signs)
 
You must log in or register to reply here.

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

Returning last number(time) in a row of cells 4
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
Calculating Shaded Cells 2
Product sum??? summing cells if a condition is true! PLEASE HELP!! 1
adding cells upto and including a specified cell 6
How to search for nearest nonblank cell in previous rows? 8
Comparison of columns using Conditional Formatting 3
Cell shading based on conditions 1

Back
Top