基本原理用条件格式新建一个rulesheet1!F2 条件“= DAY(sheet2!$G$5) = F$1”往右拖即可
http://zhidao.baidu.com/link?url=APPPvXFecJ1a8eZC5D16FF6Dn6rkXhzo_O5fQ6I1-1nQIZlwBJEKST1qEYldV6PFwzSfRBjhFwLK3CD7YppNB_上面这个!