| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif(Range, Criteria) 0
I would like to use countif(Range, A2) 0 function, if my statement is TRUE then color the cell backgroung yellow. I would like to replace the A2 in the countif function with the cell location so that I can copy the formula from cell A2 to A1677. Please me resolve this issue. Thank You, Steven |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
countif(Range, Criteria) 0
Since you use relative addressing for A2, the formula should adjust.
Make sure you use absolute addressing in Range if you want to check the same range. -- Regards, Tom Ogilvy Steven wrote in message ... I would like to use countif(Range, A2) 0 function, if my statement is TRUE then color the cell backgroung yellow. I would like to replace the A2 in the countif function with the cell location so that I can copy the formula from cell A2 to A1677. Please me resolve this issue. Thank You, Steven |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =Countif(range, criteria) | Excel Discussion (Misc queries) | |||
| Countif with a Range of criteria | Excel Worksheet Functions | |||
| countif, range and criteria | Excel Discussion (Misc queries) | |||
| CountIf for a range with multiple criteria | Excel Discussion (Misc queries) | |||
| SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions | |||
Linear Mode
