Hi all!!
I'm trying to compare to dates, if the completed (G9) is greater than the due date (F9) by using the following:
=IF(G9>F9,FALSE,TRUE)
In some cases I do not have a value in Column G and the output is defacto TRUE, how can I get it to display nothing if there is nothing in G?
I was then thinking of adding a conditional formatting on Column G to say that if Cell G = FALSE the cell would be filled RED - is ther a better way of doing this?
Many thanks,
.//p