阅读背景:

Excel VBA - 如何在条件格式中忽略空白单元格

来源:互联网 

I am trying to highlight cells that have a date less than today's date. However, when applying conditional format, "ALL" blank cell's are highlighted. I am aware of specifying the range (I2:I200), but the report is run on a daily basis which can consist of 1 to 200+. This is why I need the entire column formatted. I am trying to highlight cells that have a date




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: