Hi All,
I am having a problem with Excel conditional formatting. I have a make table query in Access that makes the table then I have an excel spreadsheet that displays the query results. The conditional formatting stopped working when I concatenated another field with the fields that have conditional formatting. Here is the twist though. If I take those columns and use the text to columns under the data property at the top of an excel sheet then the conditional formatting works fine. Is there anyone that would know how to fix this? or can point me in the right direction?

Let me know if you need clarification

Larry