Conditional formatting with IF function and Minimum function

%3CLINGO-SUB%20id%3D%22lingo-sub-2400515%22%20slang%3D%22en-US%22%3EConditional%20formatting%20with%20IF%20function%20and%20Minimum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400515%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20finding%20the%20minimum%20calue%20of%20each%20cells%20in%20%C3%A8%20different%20tables%20and%20need%20to%20return%20the%20lowest%20value%20to%20the%201st%20table%20along%20with%20the%20cell%20colour.%20Kindly%20help%20me.%20Thank%20you%2C%20Raghu%3C%2FP%3E%3CP%3EThis%20is%20the%20formula%20I%20used%3C%2FP%3E%3CP%3E%3DIF(MIN(B14%2CL14%2CB26%2CL26%2CB37%2CL37)%3D%22L37%22%2CTRUE%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2400515%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400800%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20IF%20function%20and%20Minimum%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1067404%22%20target%3D%22_blank%22%3E%40raghujai07%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22B37%22%20is%20a%20text%20value%2C%20not%20a%20cell%20reference.%20Remove%20the%20quotes%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(MIN(B14%2CL14%2CB26%2CL26%2CB37%2CL37)%3DL37%2CTRUE%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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)

2 Replies

@raghujai07 

"B37" is a text value, not a cell reference. Remove the quotes:

 

=IF(MIN(B14,L14,B26,L26,B37,L37)=L37,TRUE,FALSE)

@raghujai07 

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.