Thread: excel macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joshua Fandango Joshua Fandango is offline
Member
 
Location: In a hole in the ground there lived Joshua Fandango
Posts: 30
Default excel macro

Hi Nilesh,

Interesting question. Will every cell that contains the * be 5
characters in length?

JF

On 27 Nov, 15:51, Nilesh Bhuvad wrote:
if in cell(a1).value = "1544*". and in cell(a2).value = "4144".
How to write syntax if cell value containing character "*", then *only "*" will become red in colour and other character of the cell will remain as it is.