• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting for averages

jazzkid

jazzkid

Member
I need to apply conditional formatting for averages for a group of hospitals. There are 82 questions and each hospital supplies their results and the average for each question is calculated.


I thought that there is possibly a way to apply a conditional format to highlight if the individual hospital is above the average for each question. It will take quite some time to do this line by line, and I thought that there is possibly a way to do this for the whole sheet rather than line by line.


The spreadsheet can be found at http://db.tt/jmuOVfJa


Thanks for any assistance.


Sue
 
I had thought that what I had done would sole the issue - but it didn't. When I went to a row further down, the average had been based on the first row.


Later today I will update the document to show what I mean. In the interim, if anyone has any easy method of doing this, can you let me know please.
 
Hi Sue ,


With your cursor in cell C5 , click on Conditional Formatting , and select the New Rule that says :


Format only cells that contain


Format only cells with


Cell Value


greater than


=$N5


The last one ( =$N5 ) needs to be changed from =$N$5 which appears when you click on the cell N5.


Copy this format to all other cells ; don't be concerned even if the CF formula displays N5 everywhere ; it will work correctly as you go down the rows.


Narayan
 
Hi Narayan


Thanks for the response. I am still struggling with this for some reason.


Each time I try to change =$N$5 to =$N5 it automatically reverts to =$N$5 when I click apply.


Also you say to copy the format to all other cells. How do I do that? as when I am in a cell there is no obvious information in the cell indicating the formatting. I have tried a few different tactics - but nothing is copying the format.


Thanks


Sue
 
Hi Sue ,


Use the Format Painter to copy the format ; alternatively , in the applies to box in the CF dialog , enter the full range that you have C5:M91


Can you check this worksheet ?


https://docs.google.com/spreadsheet/ccc?key=0AkKMpuzr3MTVdDlwdVVaMEZVT3lycFJGSGhreVVCUFE


Narayan
 
You must log in or register to reply here.
Back
Top