Select the B cells in question
Use Format | Conditional Formatting
Use Formula is: =AND(NOT(ISBLANK(A1)),ISBLANK(B1), NOT(ISBLANK(C1)))
and set a pattern (bright red?)
If A and C are not blank while B is the cell with have a bright colour.
Any good?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dileep Chandran" wrote in message
oups.com...
Hello everybody,

How can I get a warning message, if I enter any text in A1 and left B1
blank and proceeded to C1?

Appreciate any help in advance

Thanks

DC