I have the table below:
<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
Date | Product | Price | |
<tbody> </tbody> | ezf | 45 | |
<tbody> </tbody> | ezffez | 10 | |
<tbody> </tbody> | ae | 56 | |
<tbody>
</tbody>
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