Previous Topic Next Topic

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

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

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.
Thanks.
Related:

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses