View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 271
Default Cell insertion if values not matching

Thanks in advance for your help!

I have created a spreadsheet to inventory equipment that have GPS units -

I need help in working through some formatting or Macro, ???

I have placed my master equipment listing in Row B
The exported GPS listing Equipment number in Row C
If they match - Row A has conditional formatting to indicate color Green &
'Verified'

What I need is if they do not match -
If row C row B, insert blank cells in row on columns C,D, & E and shift
cells down to continue the verification process thru the entire 400 piece
listing.

--
Thanks!
Susan