Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I have a group of cells, the colour of the cell is dependant on it's
value being either higher or lower than 'x'. The problem I have is that 'x' isn't constant throughout the cells. Example: A1 = higher or lower than 10 A2 = higher or lower than 7 A3 = higher or lower than 25 etc. These aren't the true values, just examples. Higher than 'x' the cell is green, lower and it's red. What formula, if any, do I put into another cell that can count the green or red cells in a given range? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Colours in Excel | New Users to Excel | |||
Counting cell colours | Excel Worksheet Functions | |||
Counting colours | Excel Worksheet Functions | |||
Counting colours | Excel Discussion (Misc queries) | |||
Counting Colours | Excel Programming |