Forum Discussion
Excel: Change cell color based on formula result
I have two cells containing data; one cell has text (A, B, C, etc) and one cell has numbers (1, 2, 3, etc). A third cell has a formula which accesses the first two cells ( =C3&" "&D3 ). For example...
Thanks for all the comments folks. I figured out what the issue was. The formula being used in the third cell was =C3&" "&D3
It should have been =C3&""&D3 (no space between the quotation marks).
In that case, you might as well use =C3&D3
