I have three basic (for programmers) conditional formatting problems
to solve in Excel for which I require some help. These are the last 3
conditions I need to complete for the worksheet so any help will be
really appreciated. They are as follows:

1.
If cell Y2 is 0 and cell Z2 = 0 I need to change the colour of cell
Z2

2.
If cell Y2 or cell AA2 0 and cells V2, W2, or X2 = the value "Z" I
need to change the colour of the cell containing "Z" (V2, W2 or X2).
If changing the colour of only the single cell containing "Z" cannot
be done, I guess changing the colour of the whole row would be okay.

3.
If cell Y2 or cell AA2 0 and cell R2 < 100 I need to change the
colour of the row

Thanks to the google group community in advance!

go to the name box on the left of the formula bar and enter

2:5642
hit enter

This should select rows 2:5642 with cell A2 as the activecell

Do Format=Conditional Format

Change the first dropdown from Cell Value Is to Fromula is.

Put in this formula

=AND(OR($Y20,$AA20),$Z2=0,IsNumber($Z2),or(isnum ber($Y2),isnumber($AA2)))

select your format and OK out.

answered your original question (now situation 3).


Condition 2:
select V2:X5642 with V2 the activeCell

=And($Y20,isnumber($Y2),V2="Z")


Condition 3:
Select Z2:Z5642, Z2 the activecell

=And($Y20,Isnumber($Y2),IsNumber($Z2),$Z2=0)

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I have three basic (for programmers) conditional formatting problems
to solve in Excel for which I require some help. These are the last 3
conditions I need to complete for the worksheet so any help will be
really appreciated. They are as follows:

1.
If cell Y2 is 0 and cell Z2 = 0 I need to change the colour of cell
Z2

2.
If cell Y2 or cell AA2 0 and cells V2, W2, or X2 = the value "Z" I
need to change the colour of the cell containing "Z" (V2, W2 or X2).
If changing the colour of only the single cell containing "Z" cannot
be done, I guess changing the colour of the whole row would be okay.

3.
If cell Y2 or cell AA2 0 and cell R2 < 100 I need to change the
colour of the row

Thanks to the google group community in advance!