Two Formatting Questions:

[Jiveman7]

Hi,

I have two relatively simple formatting questuons:
1. If i want cell A4 to be colored green, for example, when cells A1-A3 have a value of 10, do i use conditinal formatting, or an IF function. I tried conditional formatting but couldn’t get it right :/

2. If i want cell B1 to be colored red if the date in cell B2 is past the date written on B3, how would i do that?

Thx
jiveman

[Logit]

.
1. If i want cell A4 to be colored green, for example, when cells A1-A3 have a value of 10, do i use conditinal formatting, or an IF function. CONDITIONAL FORMATTING

2. If i want cell B1 to be colored red if the date in cell B2 is past the date written on B3, how would i do that? CONDITIONAL FORMATTING

[Olly]

What do you mean by "when cells A1-A3 have a value of 10"?

Do you mean that A1 = 10, A2 = 10 and A3 = 10?
Or do you mean that at least one of cells A1:A3 = 10?
Or do you mean the SUM of A1:A3 = 10?
Or something else?

[Pete_UK]

In both cases you would use conditional formatting.

In the first case you should select cell A4 then click on Conditional formatting | New Rule | Use a formula... , then you can put this formula in the dialogue box:

=SUM(A1:A3)=10

then click on the Format button | Fill tab and select green, then OK your way out. Re-reading through your post, I'm not sure if you want the total of cells A1 to A3 to add up to 10 (which is what the formula above assumes), or if you want all three cells to contain 10. If the latter, then this formula should be used:

=COUNTIF(A1:A3,10)=3

In the second case you should select cell B1 and used the same procedure, with this formula:

=AND(B3<>"",B2>B3)

and apply a red fill.

Hope this helps.

Pete