COUNTIF()

M

Mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Word macro that can call cells out of Excel for a find and replace 0
countifs Function not giving desired result with date criteria 2
=Sumproduct Question 0
Create if partial match then copy and paste data from one cell to another 1
Dynamic pointing to a cell 0
Remove specific cells in a column. 2
countif(Range, Criteria) > 0 1

Top