Is there a formula I can use to capture only highlighted cells in a row?

What do you mean by "capture"? You can process each cell in a selection this
way...

Dim C As Range
For Each C In Selection
' Your code for each cell in selection would go here
Debug.Print C.Address, C.Value
Next

In the above example, the code will print out (in the Immediate window) the
address and value for each cell currently selected.

Rick


"Joey" wrote in message
...
Is there a formula I can use to capture only highlighted cells in a row?

It's the results from a Conditional format. I now have a column of 5000
records with some highlighted and would like to move those highlighted cells
into another column.



"Rick Rothstein (MVP - VB)" wrote:

What do you mean by "capture"? You can process each cell in a selection this
way...

Dim C As Range
For Each C In Selection
' Your code for each cell in selection would go here
Debug.Print C.Address, C.Value
Next

In the above example, the code will print out (in the Immediate window) the
address and value for each cell currently selected.

Rick


"Joey" wrote in message
...
Is there a formula I can use to capture only highlighted cells in a row?

Ah, I mistook what you meant by "highlighted". There are two approaches that
can be taken here... either examine the range, in code, for cells which meet
the criteria (formula) you used in your Conditional Format or examine the
cells for the specific format that was actually applied. Either way, you
need to tell us the formula/criteria you used in the Conditional Format and
also the specific formatting you applied.

Rick


"Joey" wrote in message
...
It's the results from a Conditional format. I now have a column of 5000
records with some highlighted and would like to move those highlighted
cells
into another column.



"Rick Rothstein (MVP - VB)" wrote:

What do you mean by "capture"? You can process each cell in a selection
this
way...

Dim C As Range
For Each C In Selection
' Your code for each cell in selection would go here
Debug.Print C.Address, C.Value
Next

In the above example, the code will print out (in the Immediate window)
the
address and value for each cell currently selected.

Rick


"Joey" wrote in message
...
Is there a formula I can use to capture only highlighted cells in a
row?

Formula is - =COUNTIF($A$1:$B$3395,B12)1



"Rick Rothstein (MVP - VB)" wrote:

Ah, I mistook what you meant by "highlighted". There are two approaches that
can be taken here... either examine the range, in code, for cells which meet
the criteria (formula) you used in your Conditional Format or examine the
cells for the specific format that was actually applied. Either way, you
need to tell us the formula/criteria you used in the Conditional Format and
also the specific formatting you applied.

Rick


"Joey" wrote in message
...
It's the results from a Conditional format. I now have a column of 5000
records with some highlighted and would like to move those highlighted
cells
into another column.



"Rick Rothstein (MVP - VB)" wrote:

What do you mean by "capture"? You can process each cell in a selection
this
way...

Dim C As Range
For Each C In Selection
' Your code for each cell in selection would go here
Debug.Print C.Address, C.Value
Next

In the above example, the code will print out (in the Immediate window)
the
address and value for each cell currently selected.

Rick


"Joey" wrote in message
...
Is there a formula I can use to capture only highlighted cells in a
row?

I also selected a lavendor color to highlight the cells with

"Joey" wrote:

Formula is - =COUNTIF($A$1:$B$3395,B12)1



"Rick Rothstein (MVP - VB)" wrote:

Ah, I mistook what you meant by "highlighted". There are two approaches that
can be taken here... either examine the range, in code, for cells which meet
the criteria (formula) you used in your Conditional Format or examine the
cells for the specific format that was actually applied. Either way, you
need to tell us the formula/criteria you used in the Conditional Format and
also the specific formatting you applied.

Rick


"Joey" wrote in message
...
It's the results from a Conditional format. I now have a column of 5000
records with some highlighted and would like to move those highlighted
cells
into another column.



"Rick Rothstein (MVP - VB)" wrote:

What do you mean by "capture"? You can process each cell in a selection
this
way...

Dim C As Range
For Each C In Selection
' Your code for each cell in selection would go here
Debug.Print C.Address, C.Value
Next

In the above example, the code will print out (in the Immediate window)
the
address and value for each cell currently selected.

Rick


"Joey" wrote in message
...
Is there a formula I can use to capture only highlighted cells in a
row?