Forum Discussion
Cell matching into another cell
Hi, I need to cross reference values in 2 different cells, and depending on if one is higher or lower than the other populate a different cell with a colour. What I also want to do is depending o...
Hi Mark,
Sure. Apply Conditional Formatting (shall be in Ribbon menu) to cell F based on formula, five rules practically same way as you formulated them here. e.g. first rule =($D1-$E1)<0.1, select formatting (green) and apply to $F1.