View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Warning message if one column contains any text and another column is blank

Hi DC

One option is to set a conditional format in C1.

eg Formula Is =AND(A1<"",B1="") and set FormatPatterns to a background
colour.

--
Ian
--
"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