I have an Excel Spreadsheet that contains a formula in cell B2 that shows the
current month and year. In columns E4 to Q4 are headings that reflect each
month. Beneath each of the headings are 21 rows which contain monetary
amounts, however they can also contain zeros. I am trying to apply a
conditional format that will perform two functions. Firstly for the months
which have not yet been reached I want the column to contain a fill colour of
yellow and if the cell contains a zero I would like this text to be shown as
grey. If the month has been reached I would like there to be no fill colour
and I would still like the zero values to be shown as grey.