View Single Post
 
Old 04-21-2012, 06:25 PM
grizz grizz is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

not sure what you need but if you need the number from sheet 2 coloured in sheet 1 you should click A in sheet 2 and name it ( I names it List ) then sheet 1 highlight your sheet and go to conditional format / formula is
Code:
=ISNUMBER(MATCH(A1,List,0))
Attached Files
File Type: xlsx conditional format.xlsx (10.8 KB, 16 views)
Reply With Quote