Forum Discussion
Help with conditional formatting
For cell A1, go to Conditional Formatting, new rule, format only cells that contain, Format only cells with: Cell Value, less than, =B1, and apply your format. Use the format painter to copy this format down through all of your cells in Column A.
For cell B1, go to Conditional Formatting, new rule, format only cells that contain, Format only cells with: Cell Value, less than, =A1, and apply your format. Use the format painter to copy this format down through all of your cells in Column B.
Hi PReagan
Thanks for the response but that didn't work. It seems to copy over just what is in that particular cell rather than the formula. I just want to be able to get excel to look at the value in the cell and see if it is less than the value in another cell and if so to turn the cells fill red. But I then need it for the rest of the columns. For example Column A1 has a number 3 in and I want to be able to turn this cell red if the number is 2 in Column B1 (less than Column A1). Then apply this to the rest of Column A. I hope that makes sense.
Select the top-left cell of the range. The use Conditional Formatting / Manage Rules and check that the range to which the formatting is applied is correct and, if necessary, edit the rule. In particular check that the cell references have the correct combination of absolute ($) and relative references.