Discuss the below:
Q: With the help of data which is attached below in an attachment Is it possible to make excel highlight (Yellow) rows of results that are over 500. I would like this to happen every time I enter a value > 500. I would also like a count at the top of the spreadsheet to display the number of times this happens for a Pre-op and an Operational.
Attachment:- Sampling.rar