Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists using Conditional Formatting
Hi,
I am trying to apply conditional formatting in order to compare two identical tables to track changes that will be made to one of them. I have followed the steps provided on this website, http://j-walk.com/ss/excel/usertips/tip073.htm, but this only works for the text that is in my tables and not for the numerical values, although it is specified that this formula should work for both numbers and text. Can you please help. I am not sure what I am doing wrong. I have followed the instructions step-by-step! I have provided below an example of my table, any of these numbers or text can be changed. 0 0 0 1 1.5 36 0 response received 0 0 0 0 0 0 0 response pending Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists using Conditional Formatting
Hmmm...
There's no reason why that shouldn't work. If you want to send a copy of the file to me I'll take a look. I won't be able to get to until tomorrow PM, though. I'm getting ready to call it a day! It's 3:00 AM at my location. If you want to do that I'm at: xl can help at comcast period net Remove "can" and change the obvious. Biff wrote in message ups.com... Hi, I am trying to apply conditional formatting in order to compare two identical tables to track changes that will be made to one of them. I have followed the steps provided on this website, http://j-walk.com/ss/excel/usertips/tip073.htm, but this only works for the text that is in my tables and not for the numerical values, although it is specified that this formula should work for both numbers and text. Can you please help. I am not sure what I am doing wrong. I have followed the instructions step-by-step! I have provided below an example of my table, any of these numbers or text can be changed. 0 0 0 1 1.5 36 0 response received 0 0 0 0 0 0 0 response pending Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists using Conditional Formatting
Are your "tables" two rows as per your posting as it's not clear to me how
your data is organised? And what CF formulae did you use? " wrote: Hi, I am trying to apply conditional formatting in order to compare two identical tables to track changes that will be made to one of them. I have followed the steps provided on this website, http://j-walk.com/ss/excel/usertips/tip073.htm, but this only works for the text that is in my tables and not for the numerical values, although it is specified that this formula should work for both numbers and text. Can you please help. I am not sure what I am doing wrong. I have followed the instructions step-by-step! I have provided below an example of my table, any of these numbers or text can be changed. 0 0 0 1 1.5 36 0 response received 0 0 0 0 0 0 0 response pending Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing two lists using Conditional Formatting
On Jun 4, 5:01 pm, "T. Valko" wrote:
Hmmm... There's no reason why that shouldn't work. If you want to send a copy of the file to me I'll take a look. I won't be able to get to until tomorrow PM, though. I'm getting ready to call it a day! It's 3:00 AM at my location. If you want to do that I'm at: xl can help at comcast period net Remove "can" and change the obvious. Biff wrote in message ups.com... Hi, I am trying to apply conditional formatting in order to compare two identical tables to track changes that will be made to one of them. I have followed the steps provided on this website, http://j-walk.com/ss/excel/usertips/tip073.htm, but this only works for the text that is in my tables and not for the numerical values, although it is specified that this formula should work for both numbers and text. Can you please help. I am not sure what I am doing wrong. I have followed the instructions step-by-step! I have provided below an example of my table, any of these numbers or text can be changed. 0 0 0 1 1.5 36 0 response received 0 0 0 0 0 0 0 response pending Thanks!- Hide quoted text - - Show quoted text - Hi Biff, I have sent you an example at your specified address. Thanks for offering to help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting/ comparing worksheets | Excel Discussion (Misc queries) | |||
Conditional Formatting to Compare to Lists | Excel Worksheet Functions | |||
Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) | |||
Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) |