Conditional Formatting

[MattB]

Using the following formula:
=LEFT($L1,2)="O-"
highlights the entire row if it meets the criteria, if I only want to highlight between columns A to L then how would the formula look?

Thank you all for your patience, I know I still have a great deal to learn but I feel so much more confident about Excel since finding this wonderful site.
Thanks again

 

[Mudface]

I haven't tested this, but if you just select columns A to L and enter the formula you already have, then that should work OK. (n.b. if you have conditionally formatted the entire sheet, you will need to delete the formatting first then do the above).

 

[Aladin Akyurek]

Just select the column indicators A to L, then apply cond format with the formula you have.

 

[MattB]

Of course it does.
Sorry to waste your time Mudface, I must start thinking more logically!

 

[Aladin Akyurek]

On 2002-05-01 02:36, MattB wrote:
Of course it does.
Sorry to waste your time Mudface, I must start thinking more logically!

How about my time ?

Relax: just kidding.

 

[s-o-s]

There is a way that you can program the whole row...

Enter the conditional formating as follows

Formula is =AND(LEFT($L1,2)="O-",COLUMN()<13)

This can be entered throughout the whole line.