1)In order to make a recommendation other than conditional formatting,
we'd need to see what "did not seem to meet my needs" means to you...

Seems to me that you could select the rows to be formatted, with, say,
row 1 active, format them as yellow, then choose Format/Conditional
Formatting...

CF1: Formula is: =COUNTA(1:1)0
Format1: <patterns/<blue


2) in that case, select the range to be formatted (with, say row 1
active), format it as yellow, then use 2 conditions:

CF1: Formula is: =$A1(TODAY()-30)
Format1: <patterns/<white

CF2: Formula is: =COUNTA(1:1)0
Format2: <patterns/<blue

In article .com,
wrote:

I actually have a few questions and I don't know whether there is a
way of doing the following:

1--I am trying to look for a way to change the colour of a row if a
cell in that row is not blank.

For instance, if H3 is not blank, then the row is blue and if it is
blank then the row is yellow.

I know there is conditional formatting, but that did not seem to meet
my needs.

2--Also, is there a way that if today's date is more than a month from
a date in a cell, the row can become white?


I'd appreciate any feedback on these questions and I know they are
somewhat confusing at first blush!

Thanks