Need cells to fill blue if they contain the letter "E" 1

[kidnos]

Hi, I have a row of data in excel that pulls from another data source. It is basically a bunch of past and future dates. For the future dates they have an 'E' on the end, so it would be 2008E. I would ultimately like the cell to fill blue if the it contains the text "E". I tried to conditional format it but couldnt get it to work (maybe b/c it is linked to a data source). Thanks

 

[SkipVought]

Hi,

Please do not refer to STRINGS in Excel as DATES.

Check out Format > Conditional Formatting
[tt]
Formula is: =FIND("E",A2)>0
[/tt]
assuming that the data starts in A2

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}