Conditional Formatting and Changing Cell Colours
 

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!

Conditional Formatting and Changing Cell Colours
 

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!