Please review this article
http://www.contextures.com/xlcondFormat01.html
If this post helps click Yes
--------------
Jacob Skaria
"Sul@MS" wrote:
I have a spreadsheet that consists of 100 columns with 100 rows;
How can I highlight a cell whose value exceeds 500? tia