Forum Discussion
Solved
Help with conditional formatting
Hi I have set up conditional formatting in one cell but I need to copy this over to all cells in that column. Is there an easy way to do this rather than having to redo the rule in each cell? ...
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.
Alternately, you can select the cell with conditional formatting and double click the "Format Painter" then select any other cell that you would like to apply the conditional format to.