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