View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Scheduleing Employee Twice

Make sure you set a Pattern Color in the conditional formating. Blanks in
both cell will also cause a matching condition. Is B4 and H4 the drop down
boxes?

"Matlock" wrote:

Not sure if I am doing it right.

When I open a Conditional Format and imput =(B4=H4) in Cell B5, it
automaticly converts it to whatever format I set, even if I put a name in the
cell B4 or not.