Forum Discussion
Solved
Conditional Formatting CONCATENATE formula
Dear experts, I am having issues with my concatenate formula for conditional formatting. The formula uses a legend when concatenating two cells to show a specific colour, although the formula only u...
In all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.
In all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.
