Conditional Formatting and Changing Cell Colours

[gregglazar]

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!

 

[Tom Ogilvy]

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($Y2>0,$AA2>0),$Z2=0,IsNumber($Z2),or(isnumber($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($Y2>0,isnumber($Y2),V2="Z")


Condition 3:
Select Z2:Z5642, Z2 the activecell

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