Highlight only last cell in column that has values if a condition is met

[duteberta]

I'm struggling to find the write formula to write in Conditional Formatting to highlight ONLy the last cell in each column that has a value but only on the condition that a value above is met.

So in my case if the value in Row 6 = "YES" then highlight the last cell in that column that has a value. I tried using this to no avail...

=IF(C$6="YES",COUNTA($C$5:$C$999)=ROW($C11))

Here is a screenshot of what I'm working on...

 

[Fluff]

Try

=and(C$6="YES",COUNTA(C$11:C$999)=ROW()-row(C$11)+1)

 

[duteberta]

Once again thank you very much!

 

[Special-K99]

There are no row numbers in your screenshot, but your formula is checking for C6 to be YES.

Select A11 to wherever your conditional range ends
=AND(A$6="YES",A11<>"",A12="")

This assumes to blanks in a column will indicate no more date

 

[dreid1011]

Or this:

Book1
	C	D	E	F	G	H	I	J
5	Name	Name	Name	Name	Name	Name	Name	Name
6	No	No	No	No	No	No	Yes	No
7	Serial	Serial	Serial	Serial	Serial	Serial	Serial	Serial
8	Model	Model	Model	Model	Model	Model	Model	Model
9
10	Battery	Battery	Battery	Battery	Battery	Battery	Battery	Battery
11	Info1	Info1	Info1	Info1	Info1	Info1	Info1	Info1
12	Info2	Info2	Info2	Info2	Info2	Info2	Info2	Info2
13	Info3	Info3	Info3	Info3	Info3	Info3	Info3	Info3
14						Info4	Info4
15						Info5	Info5
16							Info6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C11:J20	Expression	=IF(C$6="Yes",COUNTA(C11:C$20)=1)	text	NO

 

[Fluff]

Glad we could help & thanks for the feedback.