View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
theo theo is offline
external usenet poster
 
Posts: 66
Default hi-lite missing field with macro

Hi I've seen some samples, but not exactly what I'm looking for

If data entered in column A:

= A, then check the corresponding row, columns B, M and R - if these are
blank highlight them in yellow
= D, then check the corresponding row, columns C, D and S - if these are
blank
highlight them in yellow

Any help is appreciated!!
T