Your question is confusing so I don't quite understand what you want to do.
It sounds like you want conditional formatting. Here is what I think you
want to do. If not please be more specific.
1. Highlight columns A-F and select Format->Conditional Formatting
2. Select "Formula Is"
3. Type: =$F1="A"
4. Select the formatting you want. You said highlight, so go to patterns
and select the color you want.
This will highlight the row (From A to F only) when the cell in column F
equals "A". It is not case sensitive. If you want the whole row (A-IV) to
be highlighted, then select the whole worksheet before using conditional
formatting.
