Conditional Formatting

MattB · May 1st, 2002, 03:27 AM

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 · May 1st, 2002, 03:31 AM

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 · May 1st, 2002, 03:34 AM

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

MattB · May 1st, 2002, 03:36 AM

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

Aladin Akyurek · May 1st, 2002, 03:39 AM

Quote:

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 · May 1st, 2002, 04:12 AM

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.

May 1st, 2002, 04:12 AM	#6
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	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. __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 03:27 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	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

May 1st, 2002, 03:31 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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).

May 1st, 2002, 03:34 AM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Just select the column indicators A to L, then apply cond format with the formula you have.

May 1st, 2002, 03:36 AM	#4
MattB Board Regular Join Date: Mar 2002 Posts: 62	Of course it does. Sorry to waste your time Mudface, I must start thinking more logically!