SOLVED

Conditional Formatting CONCATENATE formula

Contributor

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. 

 

milo1234_0-1617961508575.png

 

 

 

 

2 Replies
best response confirmed by milo1234 (Contributor)
Solution

@milo1234 

In all the rules, change CONCATENATE(E3,F3) to CONCATENATE($E3,$F3)

See the attached version.

Thank you so much @hans!