You do not need code

Select C5
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =NOT(ISNUMBER(C5))
Click the Format button
Select the Pattern Tab
Select Blue
OK
OK

Second condition

Select C6
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =AND(ISNUMBER(C6),C6<.5)
Click the Format button
Select the Pattern Tab
Select Red
OK
OK

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"FARAZ QURESHI" wrote in message
...
Can any1 help me simply writing a code to highlight the cell (C5) to Blue
if
its value
is not numeric and similarly...

highlight the cell (C6) to Red if its value is numeric but below < 5?