View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gregglazar@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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!