Hi,
<colgroup><col></colgroup><tbody>
</tbody>
I have data in Column A, A1 Column heading, A2:A10 - data, row A11 is blank A12:A16 -data, row A17 is blank & so on.. |
Data in A2:A10 will be like this - A2 - "J554-Sales1" A3 - "J554-Sales2" A4 - "J456-Export1" etc,. |
Now, I want a conditional format in entire column A:A, where first four Characters in each cell A2:A4 in which the data is present not equal to "J554", the cell has to turn red color |
<colgroup><col></colgroup><tbody>
</tbody>