May 31 2021 02:46 AM
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 formula I used
=IF(MIN(B14,L14,B26,L26,B37,L37)="L37",TRUE,FALSE)
May 31 2021 04:04 AM
"B37" is a text value, not a cell reference. Remove the quotes:
=IF(MIN(B14,L14,B26,L26,B37,L37)=L37,TRUE,FALSE)
May 31 2021 07:13 AM
If to colour cells without VBA, using conditional formatting rules, you need as many rules as colours do you have. With that in current logic you may use formulas for the rule like
=B3=$B$26:$I$33
for the blue colour, applying the rule to $B$3:$I$10
Same for other colours.