View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
erregsec erregsec is offline
external usenet poster
 
Posts: 6
Default conditional formatting

I am not sure how to set up the conditional formatting for the following:

I have a group of employees who work with patient accts. So, in cell B2, B9,
B16, B23, B30, B37 and B44 is the number of patients that each employee
worked with that day. In cell B51 I have it set up to average all of the
numbers in those cells just listed. What I want to do is set up a conditional
format so if they are within five above or five below that average, their
cell turns one color. If they are more than five below the average the cell
turns a different color and if more than five above the average it turnes a
different color. That way they can see at a glance if they are working within
the average. Can someone help??