Select your range of data.
In conditional formatting use this rule
=MATCH(TRUE,INDEX($A2:$F2="",0),0)=COLUMN()
format -- yellow
Ok
Select your range of data.
In conditional formatting use this rule
=MATCH(TRUE,INDEX($A2:$F2="",0),0)=COLUMN()
format -- yellow
Ok
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks