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.