First thanks for your time!
I'm trying to do something rather easy (I think). I would like to conditional format a column of historical dates. In this column I would like to highlight the first month of each fiscal year (April).
I'm unsure how to type this in logically into the conditional format formula? (Excel 2007).
I tried "=Month()=4" which does not work. Sometimes I wish we could just use simple algebra to do excel functions! A=Month(x) when A = 4, format cell!
Thanks a ton,