How do I set up "rules" for data analysis?

[Samsowl]

Hello everyone!

I've joined this forum in hope I can learn a bit more about excel! My first task is to apply the same rule (with a different... value that determines whether values within a row follow the rule or not... for each row) - This will make more sense when you see the excel sheet!

Anyway, I have 100 different sets of experimental data. I've put some mock data together for 3 different sets of experimental data to use as an example.

So if you dare to open the excel file and take a whack at this one!....


The two things I'd like to achieve:

-This means each row will have a different rule, but i want the same thing for 100 of these graphs, this is just 3 examples.
-It would also be good to make it so that if the box above a box, such as in column D - Lets say box D11 (greater than the orange column number (T11), would colour RED, D12 would not, but D13 would colour RED. Becuase above it there has been a box that has not gone red, i dont wnat anything below a box that doesnt go red, to go red... if that makes sense. Once I find my end point, I don't want it to keep applying the rule to go red


If anyone has any idea how to do this I will be forever greatful! Imagine doing this all manually! :P

Thanks guys

Samantha.

[TMS]

See the attached example.

Applied to: =$D$5:$M$20, the formula is: =D5>=$T5

You can copy and paste the formatting to the other cells/ranges.


Regards, TMS

[Samsowl]

Brilliant!

That helps alot thanks!
Would it be possible to tackle the second thing I wanted to do? Or is what i'm asking impossible? Basically what i'm trying to say is if you look down a column, if there's a box that doesn't meet the rule (i.e. stays white and doesn't turn red) - can i make it so that the rest of the boxes down that column under that one don't go red, even if they meet the rule by being above the mean+3*stdev?

Thanks a million also for the quick response! ,

Samantha.