I wonder if anyone can help me, I have a spreadsheet with Registration Numbers on them and I want to be able to type a Reg No on sheet 1 but if the same reg is entered on Sheets 2 it will highlight in Red on Sheet 1.
Does anyone know what the formula is for this that I need to use when using Conditional formatting?
Shazz
you can use conditional format or data validation
Conditional format example attached
Sadath31 forgot to mention to use conditional formatting across sheets you need to use named ranges
if you look in name manager you will see a named range called "myrange" refering to sheet1!A:A
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks it works perfect.
Shazz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks