excel
 

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

excel
 

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

excel
 

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

excel
 

Works for me! I wanted the total of a colum to be red if <0 to show a lose
but didn't know how to accomplish this. Now I do.

Thanks Peggy!
--
David


"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

excel
 

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!