"Marc's NYK" wrote:
I need a cell (a2) to highlight if the last cell within a range (F2:V2) that
is not blank = the word "PENDING"
For the above specs as posted,
you could try this:
Select A2, then apply CF using Formula Is:
=INDEX(F2:V2,INDEX(MAX((F2:V2<"")*COLUMN(F2:V2))-COLUMN(F2)+1,))="pending"
Format to taste, ok out
voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---