I have a problem. I have a spreadsheet that I want to highlight an entire row based on the criteria in one cell. But I want it to be real time i.e. not all the information is in the spreadsheet but as I enter it, if it meets certain criteria I want the entire row highlighted. I am using Excel for Mac, but can use Excel for Windows if need be. Also I am running Excel 2011. If you need more information please let me know