An impossible formula???

[ran_heath]

Is this even possible? I am looking to format a cell based on two conditions, but I dont think it can be done? LookUp a date or fist non-empty cell and then compare the values to see if it is less than or equal to 80% of the target...
MsgBox ActiveSheet.Range("A65536").end(x1up).address
Displays a message box with the first nonempty cell, but what about in a range? I am trying to find bits and peoces and then force them together...
Any suggestions?
How do I look up the current month and then shade the box red if the current month APC or PPC is less than 80% of my target total (PGA)? I can change each month red via the conditional formating; however, I need this box to turn red.
http://www.mrexcel.com/board2/viewtopic.php?t=236789&highlight=lookup+format+particular+cell

 

[Smitty]

Duplicate Post.

Please stick to your original thread. If you're worried because it's dropped down or to another page, simply reply to it with "BUMP" as your message.

Note in your original post you might want to try posting with Colo's HTML Maker, which will give a larger shot.

Smitty