Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
484 Posts
Discussion Starter · #1 ·
Hi,

Im trying to create a Excel macro which scans the worksheet and if it finds a:

( ) in there then to colour it.

Between the brackets will be a number.

Any Ideas?

Cheers,

Jon
 

·
Registered
Joined
·
8,546 Posts
"if it finds a: '( )' in there then to colour it."

So ... the cells in question are formatted as text?

"Between the brackets will be a number."

OK. But when you say "colour it", what is "it"? The number between the brackets? The number and the brackets? The entire cell? Might the cell content be more, such as:

Here's the news at ten (10)

?

Anyways, why a macro? Why not just a CF formula, such as:

=SEARCH("(*)",A1)>0

?

(sorry for all the questions :) )
 

·
Registered
Joined
·
484 Posts
Discussion Starter · #3 ·
Hi thanks for getting back to me...

"if it finds a: '( )' in there then to colour it."

So ... the cells in question are formatted as text? - Yes

"Between the brackets will be a number."

OK. But when you say "colour it", what is "it"? The number between the brackets? The number and the brackets? The entire cell? Might the cell content be more, such as:

Here's the news at ten (10) - I want the entire cell.

Anyways, why a macro? Why not just a CF formula, such as:

=SEARCH("(*)",A1)>0 - Basically I want a button to press so I can show all the data with and without the cell coloured.

(sorry for all the questions :) )
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top