Forum Discussion
Solved
Price comparison between a range of cells
Hello, Basically I'm working with 6 columns, where column C represents the total amount of products, columns D, E, F and G the value of each company on top of that total amount. I want to know if...
- It worked perfectly, thanks for the help, but what is the function of "$" in the conditional formatting?
The "$" before columns D and G fixes the columns in the MIN function. For illustration i entered the rule for conditional formatting in cell D8 and copied it across range D8:G12. You can do this in your sheet and see how the formula changes in every cell. The result is the expected pattern of FALSCH and WAHR (FALSE and TRUE) and the cells are formatted accordingly.
