I would like any number put in column A to change to red and bold when it matches a number in column 1 of sheet2. Have read posts for 4 hours before crying uncle! Thanks for any help you fine folks can offer.
Kent
I would like any number put in column A to change to red and bold when it matches a number in column 1 of sheet2. Have read posts for 4 hours before crying uncle! Thanks for any help you fine folks can offer.
Kent
Last edited by Kent Kelly; 11-06-2012 at 04:31 PM.
Hello
As your reference numbers are on another sheet, you'll have to give the range a name, eg. 'NumbersList'. Then apply the following conditional formatting formula to the cells in column A on Sheet1:
Any count within the list should format the cell as required.Please Login or Register to view this content.
Hope this helps.
DBY
Thanks for the quick response! Where do I put the name of the range and how do I designate the color of the font if there is a match with a number on sheet two.
Kent
HI
Try the following:
1. On sheet2, select cells A1:A5. Click in the Name Box (directly above) and type your name, then press Enter.
2. On sheet1 select the cells in column A you wish to format.
3. Go to Conditional Formatting on the Home Ribbon, select New Rule.
4. Then: 'Use a formula to determine which cells to format'.
5. Place the formula in the dialogue box and click the Format button to select whatever formats you wish. Click OK.
Hope this makes some sense.
DBY
Last edited by DBY; 11-06-2012 at 03:42 PM. Reason: Typo
DBY,
My hat is off you sir! Thank you so much for the help. Your solution works perfectly! I joined this forum yesterday and have already become a fan
Kent
You're welcome. Glad you're finding the forum helpful.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks