View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Winshent Winshent is offline
external usenet poster
 
Posts: 8
Default Change the properties of a non selected cell?

i have some code which validates a row.. and compares two columns in
the row. The code is triggered from Worksheet_SelectionChange(ByVal
Target As Range) within the worksheet.

i want to be able to set the colours of the cells if they do not pass
validation.. how can i do this with selecting the actual cell?

Thanks

Vincent