Conditional Formatting for multiple lines

[geordieben]

I need to apply conditional formatting to all lines in a certain column in my spreadsheet

Line Type	General Ledger Account	Value	Line Description	Dimension 1	Account
Account - Vendor	7621 - G&A - Payment Processing costs	-8112​	BM Test Line Desc 1	Tanfield Village
GeneralLedgerAccount	2305 - Suspense	8112​	BM Test Line Desc 2

The formatting is on the Account column

The formatting needs to be if the Line Type of that line is Account - Vendor and the Account field is blank, then turn the Account field RED

So far I've been able to get kinda close, by either just F2 to be red, when A2 = Account - Vendor, or F2 and F3 to be red when A2 is Account - Vendor

However, in the above scenario, F3 should not be red.

How would I create my required formatting?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=AND($F2="",$A2="account - vendor")

 

[geordieben]

If I do that lines 3 and below are then looking back at line 2 to see what is populated, instead of line 3

 

[Fluff]

No they aren't

 

[geordieben]

Ok, I've tried what you said:

But then this is what, even thought B4 isn't populated

 

[Fluff]

The row in the formula needs to match the first row in the applies to range.

+Fluff 1.xlsm
	A	B	C	D	E	F
1	Line Type	General Ledger Account	Value	Line Description	Dimension 1	Account
2	Account - Vendor	7621 - G&A - Payment Processing costs	-8112	BM Test Line Desc 1	Tanfield Village
3	GeneralLedgerAccount	2305 - Suspense	8112	BM Test Line Desc 2
4
5
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:F10	Expression	=AND($F2="",$A2="account - vendor")	text	NO

 

[geordieben]

Unless I'm being totally blind the only difference between mine and yours is you're using column F whereas I'm using column G

In my original post I missed off column A as it didn't seem relevant to the query

What am I missing?

 

[Fluff]

In my example the formula & applies to range both start on row 2, in yours the formula is row 2 & the applies to range is row 5.