Apr 09 2021 02:45 AM
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.
Apr 09 2021 02:57 AM
SolutionIn all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.
Apr 09 2021 02:57 AM
SolutionIn all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)
See the attached version.