Hey guys!
My query is, is it possible to conditionally format cells that if I highlight a cell grey the font colour will be black and any cell left that is uncoloured the font colour will be white?
Basically what I have is data that is calendarised by month and for the coming months the cells are uncoloured to state that the numbers are forecast number and month on month I get the 'actual' numbers, these get entered and I highlight the cell grey to state that info is actual and not forecast.
Many thanks
Bookmarks