Advanced Conditional Formatting Help Required - Change cell colour based on values of other cells
 

I have developed the logic I require, I just need some help in writing
the code to do it as I haven't used Excel for quite some time.

Basically, I need the code to perform the following:

Example:

If Y2 or AA2 0 and Z2 = 0, I need to change the colour of cell Z2 to
red.

I need to perform this function not only on row 2, but on rows 2 to
5642

Any help will be much appreciated.

Advanced Conditional Formatting Help Required - Change cell colour based on values of other cells
 

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.

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
I have developed the logic I require, I just need some help in writing
the code to do it as I haven't used Excel for quite some time.

Basically, I need the code to perform the following:

Example:

If Y2 or AA2 0 and Z2 = 0, I need to change the colour of cell Z2 to
red.

I need to perform this function not only on row 2, but on rows 2 to
5642

Any help will be much appreciated.