LinkBack URL
About LinkBacks
mikemike 
How would I do the following?
1. Enter a value in cell B2.
2. Press a button
3. Check if value in cell B2 is a name of one of the sheets in the workbook
4. If value matches one of the sheetnames, make background of cell green, otherwise turn it red
How would I do the following?
1. Enter a value in cell B2.
2. Press a button
3. Check if value in cell B2 is a name of one of the sheets in the workbook
4. If value matches one of the sheetnames, make background of cell green, otherwise turn it red
Hi
A combined effort from JR@SGC and Chappo
1. Create a list of the sheet names
2. select the cell you want to conditional format (B2) then
3. Format > Conditional formtting...
4. when it opens change 'cell vaule is' to 'formula is' (via the drop down box)
5. enter the formula:
=IF(OR(B2=H21,B2=H22,B2=H23,B2=H24),TRUE,FALSE)
or
=If(or(B2=H21,h22,h23,h24,),true,false)
(H21 etc is our range and repeat for as many names)
6. then set your conditional formatting
Hope it works
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks