conditional formatting using a range

  • Thread starter Thread starter Marc's NYK
  • Start date Start date
M

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
 
Marc's NYK said:
I need a cell (a2) to highlight if the last cell within a range (F2:V2) that
is not blank = the word "PENDING"
Click to expand...

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