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
|