Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting of adjacent cells based on text in cell
Hello,
I have an excel sheet that is updated daily from reports in business objects. There are 2 coumns, both have an address in them, similar to below: 100 LEVALL BLVD 100 LEVALL BLVD 100 NORTH ROCKWELL SUITE 108 100 NORTH ROCKWELL 100 W GENESEE STREET 100 W GENESEE STREET 10100 DIXIE HWY 10100 DIXIE HWY I am looking to make a conditional format that says if the text in column A, doesnt match column B, turn it red, if it does match, turn it green. 99% of the time, both cells should be identicle, if the person didn't mess up. We are looking to spot quickly any errors (what would show up in red) instead of spending hours looking manually if there are differences. As seen above, rows 1,3, and 4 are good, they match exactly, where as 2 does not, and would need to show up in red to alert us we need to make a change. I cant seem to get this to work, can someone offer some assistance? -Josh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting of adjacent cells based on text in cell
Select column A and use conditional formatting formula is option with formula =A1<B1 note this isn't case sensitive. If you want it to be =NOT(EXACT(A1,B1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=569231 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on adjacent cell? | Excel Worksheet Functions | |||
Conditional Formatting Based on Value of Adjacent Cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) | |||
Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) |