Forum Discussion
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 is possible, through some formula, to select the smallest value between columns D and G and fill that same cell with green color and then multiply this value by the amount presented in C showing the result in column H.
It is a relatively easy task to do manually, but as there are several lines it would take some time and I believe it would be more susceptible to error, so any help would be welcome.
3 Replies
- 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.
