Conditional Formatting

[Marie]

Hello,
I am trying to get Excel to highlight rows based on a
condition (cell content).

I tried using Conditional Formatting but the results
aren't displaying as I expected. Column C contains two-
letter codes. For all rows, I want the following example
to occur:

If cell C6 ends with a Z or L, highlight row 6 green.
Otherwise, highlight row 6 blue.

Alternative: If cell C6 ends with a Z or L, highlight
certain cells in row 6 green, otherwise blue.

Thank you in advance, Marie

 

[Felipe]

Marie,

1. Select all the rows you want to highlight (starting in
row 6)
2. Go to conditional formatting.
3. Select 'Formula is' from the drop down menu
4. Type: =OR(RIGHT($C6,1)="z",RIGHT($C6,1)="l") Make sure
the row tyed (6) is the same as the current active cell's
row
5. Select the appropriate format
6. Click OK
7. Without deselecting the rows select the cell filling
for cells that don't comply with the condition.

Regards,
Felipe

 

[Marie]

Felipe,
Thanks again...worked perfectly.

-----Original Message-----
Marie,

1. Select all the rows you want to highlight (starting in
row 6)
2. Go to conditional formatting.
3. Select 'Formula is' from the drop down menu
4. Type: =OR(RIGHT($C6,1)="z",RIGHT($C6,1)="l") Make sure
the row tyed (6) is the same as the current active cell's
row
5. Select the appropriate format
6. Click OK
7. Without deselecting the rows select the cell filling
for cells that don't comply with the condition.

Regards,
Felipe
.