conditional formatting
 

I have some cells which look like the following:-
(they show three values from three other cells)
either 1, 30, 5
or 1, *, 5 say
where the "*" indicates a particularly large value

Now, I am trying to highlight those cells which contain an "*".
I am using SEARCH("*", A3) where A3 is the cell reference
However, all my cells whether they include an "*" or not are highlighted
What am I missing?

Bob

conditional formatting
 

Check your another post which you have posted in Worksheet Functions.

--------------------
(Ms-Exl-Learner)
--------------------


"Bob Matthews" wrote:

I have some cells which look like the following:-
(they show three values from three other cells)
either 1, 30, 5
or 1, *, 5 say
where the "*" indicates a particularly large value

Now, I am trying to highlight those cells which contain an "*".
I am using SEARCH("*", A3) where A3 is the cell reference
However, all my cells whether they include an "*" or not are highlighted
What am I missing?

Bob


.

X-Y co-ordinates
 

Hi Folks
What is the formula to sort out X-Y co-ordinates that are very close, for
instance less than 0.1mm and greater than -0.1mm?