No, or transparent, font colour

[SaraWitch]

Hello peeps,

I have had to tweak a date formula (in A1) to return a zero if the date result is 00/01/1900 (I have customised in Format Cells: [=0];dd/mm/yyyy).

I want the row to change colour once an actual date is returned in the formula. I am using a Conditional Format rule (which works):

=$A1>0

However, what I would really like to do now is hide the zero in A1 without it actually returning as a blank (I need the zero!). Is there a way of removing font colour completely or making it transparent (i.e., so I could add an additional Conditional Format to say that if A1=0, then no, or transparent, font colour)?

I fear not, but any advice would be welcomed...

 

[6StringJazzer]

Use this custom format instead of the one you are using:

dd/mm/yyyy;dd/mm/yyyy;;@

This has nothing to do with colour but will not display a 0. The 0 will still be there, just not displayed.

 

[SaraWitch]

Amazing!! Thank you so much, @6StringJazzer!