conditional formatting using a range

[Marc's NYK]

I need a cell (a2) to highlight if the last cell within a range (F2:V2) that
is not blank = the word "PENDING"

In other woerda I need the A2 cell to stay highlighted until one of the
cells have anything besides a blank or pending

 

[Max]

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
---