Forum Discussion
Solved
Filling a cell with using conditional formatting in two other cells
Hi, I've been having some hard time figuring out how to solve this. I have three columns with actual data (numbers) and would like to illustrate conclusions based on the first and third cell ...
You can try the attached file where i've entered two rules for conditional formatting. Maybe this is what you want to do.
I think you need three rules for conditional formatting based on formulas - one for each column. Note that in each rule the range to apply the rule is an absolute reference whereas the formula uses the first linenumber without "$". This iterates the formula over the range.