Conditional formatting

MattB · Apr 19th, 2002, 02:31 AM

Hi all
I have a range of different codes running down column A (starting in A4).The codes are all 12 digits long but have differing prefixes. (Eg, 1MAA66204AAD, 1HBC60583AAH,1HBA60758AAE,1HAT60925AAC).
What I would like to do is highlight the entire row when a code begins with either 1HAT or 1HBA.
Any ideas??
Many thanks
Matt

Mudface · Apr 19th, 2002, 02:43 AM

Select your entire sheet, click on format- conditional formatting and change 'Cell is' to 'Formula is'. Enter the following formula: -

=OR(LEFT($A1,4)="1HAT", LEFT($A1,4)="1HBA")

Select your format. Then select your first three rows and click on Format-conditional Formatting and delete the formats for those rows. HTH.

Aladin Akyurek · Apr 19th, 2002, 02:51 AM

Quote:

On 2002-04-19 01:31, MattB wrote:
Hi all
I have a range of different codes running down column A (starting in A4).The codes are all 12 digits long but have differing prefixes. (Eg, 1MAA66204AAD, 1HBC60583AAH,1HBA60758AAE,1HAT60925AAC).
What I would like to do is highlight the entire row when a code begins with either 1HAT or 1HBA.
Any ideas??
Many thanks
Matt

Select the range of interest from A4 by using the row indicators.
Activate Format|Conditional Formatting.
Select Formula Is for Condition 1.
Enter as formula:

=OR(LEFT($A4,4)="1HAT",LEFT($A4,4)="1HBA")

Activate Format.
Select the desired formatting.
Activate OK, OK.

MattB · Apr 19th, 2002, 02:59 AM

Works like a charm Mudface, thanks.
Aladin - Thanks also, but what was the difference?

Aladin Akyurek · Apr 19th, 2002, 03:15 AM

Quote:

On 2002-04-19 01:59, MattB wrote:
Works like a charm Mudface, thanks.
Aladin - Thanks also, but what was the difference?

Mudface's reply showed up first. The formula is the same; the procedure description is a bit different, but with the same effect.

MattB · Apr 19th, 2002, 08:42 AM

I'm attempting something similar where i need to identify any entries in column L that read "O-". I then need to highlight that entire row.
I seem to be missing the principles of what will be a simple formula. Can anybody give me shove in the right direction please?
Thanks

Mudface · Apr 19th, 2002, 09:15 AM

Do the same as before, then enter as the formula:

=LEFT($L1,2)="O-"

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

Apr 19th, 2002, 02:31 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	Hi all I have a range of different codes running down column A (starting in A4).The codes are all 12 digits long but have differing prefixes. (Eg, 1MAA66204AAD, 1HBC60583AAH,1HBA60758AAE,1HAT60925AAC). What I would like to do is highlight the entire row when a code begins with either 1HAT or 1HBA. Any ideas?? Many thanks Matt

Apr 19th, 2002, 02:43 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Select your entire sheet, click on format- conditional formatting and change 'Cell is' to 'Formula is'. Enter the following formula: - =OR(LEFT($A1,4)="1HAT", LEFT($A1,4)="1HBA") Select your format. Then select your first three rows and click on Format-conditional Formatting and delete the formats for those rows. HTH.

Apr 19th, 2002, 02:59 AM	#4
MattB Board Regular Join Date: Mar 2002 Posts: 62	Works like a charm Mudface, thanks. Aladin - Thanks also, but what was the difference?

Apr 19th, 2002, 08:42 AM	#6
MattB Board Regular Join Date: Mar 2002 Posts: 62	I'm attempting something similar where i need to identify any entries in column L that read "O-". I then need to highlight that entire row. I seem to be missing the principles of what will be a simple formula. Can anybody give me shove in the right direction please? Thanks

Apr 19th, 2002, 09:15 AM	#7
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Do the same as before, then enter as the formula: =LEFT($L1,2)="O-"