Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting using a range
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting using a range
"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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Range | Excel Discussion (Misc queries) | |||
Conditional Formatting In a Range | Excel Discussion (Misc queries) | |||
Conditional formatting - range of dates | Excel Discussion (Misc queries) | |||
Conditional Formatting for a Range | Excel Discussion (Misc queries) | |||
HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE | Excel Worksheet Functions |