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 updates the left cell and not both cells. Please help.
For example, cells E3 and F3 should both be amber and green, however cell F3 shows just green.
I have already inserted the formula into conditional formatting.
In all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.
2 Replies
In all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.
