Highlighting Cells
 

In columns A:F, the sheet is text.

I would like to highlight a row in a color, (Say A5:F:5) when an "A" is
typed into F:5

Can this be done?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=470747

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.

"comotoman" wrote:


In columns A:F, the sheet is text.

I would like to highlight a row in a color, (Say A5:F:5) when an "A" is
typed into F:5

Can this be done?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=470747

Take a look at FormatConditional Formatting, Formula Is.

HTH |:)

"comotoman" wrote:


In columns A:F, the sheet is text.

I would like to highlight a row in a color, (Say A5:F:5) when an "A" is
typed into F:5

Can this be done?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=470747