Conditional Formatting

**krombie19** · 06-30-2012, 11:37 AM

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

**jeffreybrown** · 06-30-2012, 11:43 AM

See if this helps...

**krombie19** · 06-30-2012, 11:54 AM

Thanks Jeff, but I need help getting the entire row to highlight

**jeffreybrown** · 06-30-2012, 12:01 PM

Conditional Formatting

Highlight applicable range
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true: [Enter Formula]
Format… [Number, Font, Border, Fill]
OK >> OK

For the formula, lets say you want to highlight the row if a value in column H is greater than 5

=$H2>5