Conditional Formatting: format a column if the cell above contains a specific text

[ATNCO]

I have the table below:

Date	Product	Price
01/11/1903 <tbody> </tbody>	ezf	45
03/11/1903 <tbody> </tbody>	ezffez	10
07/11/1903 <tbody> </tbody>	ae	56

<tbody>
</tbody>

and I am trying, using conditional formatting, to format a column if the cell above contains a specific text.
So for example, if in A1 I have "Date", the column below turns red.

I do not know what formula to use in Conditional Formating/New formatting rule/Use a formula to determine which cells to format.

Thank you

 

[Momentman]

If the cells are formatted as dates and not that they are strings that look like dates, then

1. Select the column with the data, say A1:A10
2. Go to conditional formatting and new formula and
3. Use a formula like =NOT(ISERR(YEAR(A1))) = TRUE to format cells that contain a date

or like =iserror(Search("txt",A1)) = false to format cells that contain the string "txt"

 

[ATNCO]

If the cells are formatted as dates and not that they are strings that look like dates, then

1. Select the column with the data, say A1:A10
2. Go to conditional formatting and new formula and
3. Use a formula like =NOT(ISERR(YEAR(A1))) = TRUE to format cells that contain a date

or like =iserror(Search("txt",A1)) = false to format cells that contain the string "txt"

It works, thank you very much!