Conditional format to shade rows if value or date is found?

sgriffis Posts 1 Registration date Tuesday August 13, 2013 Status Member Last seen August 14, 2013 - Aug 14, 2013 at 09:50 AM

I am new to conditional formatting and trying to create a few function that will work in Excel 2010.

First I am trying to grey out (or shade) all rows that contain a value less than or equal to 35 in column E.

Second I need to BOLD all rows that contain today or tomorrow's date in column G. It would be nice to exclude weekends. For example if today is Friday it would bold all columns with Friday and Monday in it.

I have not been been able to get either to work. Any help would be appreciated.