ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   COUNTIF() (https://www.excelbanter.com/excel-programming/283325-countif.html)

mark

COUNTIF()
 

I would like to use the COUNTIF function with a condition
statement, if the statement is TRUE color the cell YELLOW
and move down to the next cell. I'm using the COUNTIF
(STARTOP, A2) 0 statement. The STARTOP is a defined
array of values. How do I have the cell A2 set as the
current cell value so that I can move from cell to cell
(A2,A3,A4,....A1677) without having to change the value
in the formula.

Thank You,

Mark




All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com