Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting / Cell Fill Colours | New Users to Excel | |||
how do i get more than 3 colours in conditional formatting | Excel Discussion (Misc queries) | |||
colours missing in conditional formatting. | Excel Worksheet Functions | |||
Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
Conditional Formatting Counting Colours | Excel Programming |