Forum Discussion
raghujai07
May 31, 2021Copper Contributor
Conditional formatting with IF function and Minimum function
I am finding the minimum calue of each cells in è different tables and need to return the lowest value to the 1st table along with the cell colour. Kindly help me. Thank you, Raghu This is the formu...
HansVogelaar
May 31, 2021MVP
"B37" is a text value, not a cell reference. Remove the quotes:
=IF(MIN(B14,L14,B26,L26,B37,L37)=L37,TRUE,FALSE)