View Single Post
  #5   Report Post  
Jade Summers Jade Summers is offline
Junior Member
 
Posts: 13
Default

Quote:
Originally Posted by Jade Summers View Post
Thank you so much for your quick reply! Unfortunatly that isn't working for me. It's just turns all cells that were red (both dates and blank) no colour. However this does seem to fix the issue of putting 0/Jan/1900.

Any other ideas would be greatly appriciated!
For some reason it wasn't working without the $ in front of the F. Why I have no idea, but I am thrilled it's working. Thank you so much for your help you saved my sanity!