Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default Compare value in column AP with value entered into one of COLs D-

Is there a way to validate that a value, if entered, into column AP is the
same value that can appear only once in columns D-J for the same row? And
then have a comment popup or highlight the value in column AP which does not
match the value entered into columns D-J of the same row?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to sort a column of data which is the SUM of three cols freebird Excel Worksheet Functions 1 April 13th 09 07:57 AM
Compare & align 2 cols of Employee Names in sorted alpha order withVBA u473 Excel Discussion (Misc queries) 4 September 28th 08 05:43 PM
macro - compare data in cols n transfer to next row Johnny Excel Programming 1 December 4th 06 01:12 PM
Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error? Craigm[_53_] Excel Programming 2 May 2nd 06 11:04 AM
Cond Format:re color 2 cols, skip 2 cols Tat Excel Worksheet Functions 2 June 22nd 05 06:43 PM


All times are GMT +1. The time now is 07:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"