Conditional formatting of the last entry in the column only

Excel Help for Conditional Formatting Of The Last Entry In The Column Only in Automating Data Analysis Tasks

Conditional Formatting Of The Last Entry In The Column Only

Rate this: (3/5 from 1 vote)

	Hello, Ive got a question. I have set up conditional formatting of a cell that is my header tittle and I want it to turn yellow based on a condition of the last entry in the column only. I want the header to only recognize the last numerical entry based on any number greater than zero. Ive set up everything already, except it recognizes ALL the data and will turn yellow if ANY numbers in the column are greater than zero rather than the last entry in the column Piz help
	Jay
	Posted by environdata on 04 Feb 2011

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Conditional formula cell reference Rate this: (3.5/5 from 2 votes) You need to create a conditional formula in the header cell.  The formula should reference the last cell in the column e.g. A100>0.
	Excel Business Forums Administrator
	Posted by Excel Helper on 04 Feb 2011

	Conditional formatting of the last entry in the column only Rate this: (3.5/5 from 2 votes) Data is continuously added to each column and thus the spreadsheet leightens when new data is added. Will this formula recognize the last entry each time only?
	Jay
	Posted by environdata on 05 Feb 2011

	Dynamically find the address of the last cell Rate this: (3/5 from 1 vote) In this case, you need to change the formula to dynamically find the address of the last cell in the column. If the data is contiguous (it doesn't contain any blank cells) then you can use the following formula for column A: =IF(INDIRECT("A"&COUNTA(A:A))>0)
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 Feb 2011

Displaying page 1 of 1