Conditional format to change font color on date

[Harley78]

Hello,

I am using the formula
=MIN(IF($A14='IN TRANSIT'!$B$2:B$500,'IN TRANSIT'!$L$2:$L$500,"")) and on my report that has 752 lines. so I drag this formula down the column and I if blank, cell populates with 1/0/00. Now I want to have it not show this 1/0/00 and thought I could use Conditional formatting to change the font to white if cell contains 1/00/00.

Is there another way?

Thanks

Bill

 

[Fluff]

Maybe

=If(A14="","",MIN(IF($A14='IN TRANSIT'!$B$2:B$500,'IN TRANSIT'!$L$2:$L$500,"")))

 

[julhs]

To do it by “Condition Formating” alone.

Click on the first cell in the range that contains 1/0/00; then click Condition formatting. Select “New Rule”, choose “Cell only contains” and put in 1/0/00. Then while still in condition formatting window select “Format”, select “Font colour” and choose “White”. While still in condition formatting window click the “Red” arrow in the box on the right of “Applies to”, you will then be able to drag the selection over the range that you want, finally click “Stop if true” then ”Ok”.

 

[Fluff]

I very much doubt that will work, as the cell almost certainly contains 0 & is formatted as a date.

 

[julhs]

For my test; with $A14 formatted as "Date" this adjustment seems to work?
=$a14="1/0/00"

 

[Harley78]

Many thanks All! Appreciate the help in solving this.

 

[Fluff]

Glad to help & thanks for the feedback.