On May 24, 5:01 pm, pshepard
wrote:
Hi Ashley,

To apply colors to blank or non-blank values:

1. Select the Region of cells to apply formatting to; assume the first row
of data is row 3, then select a range like A3:Z100.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select Formula Is, and type ="" =$H3.
4. Click Format, select the Font tab, select a color, and then click OK.
5. In Condition 2, select Formula Is, and type =""<$H3.
6. Repeat step 4, select a different color than you selected for Condition
1, and then click OK.

Note: Be sure to distinguish between absolute reference and relative
reference when entering the formulas.

Let me know if this helps.

Thanks,
Peggy



" 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- Hide quoted text -

- Show quoted text -

Thanks Peggy! (I'm sorry I was on vacation and I just saw your
message now.) You are a life saver! It works beautifully and will
make my life so much easier.

Thanks again!