excel

A

ashley.odonnell

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
 
J

JE McGimpsey

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>
 
P

pshepard

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
 
D

David

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!
 
A

ashley.odonnell

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











- Show quoted text -
Click to expand...

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!
 
Top