Can I use conditional formatting to format a cell based on color in the cell itself and the cell before?

Question

Conditional formatting Excel 2010 how to format a cell based on color in the cell itself and the cell before.

I have with Conditional formatting marked a start cell and end cell with red I want to get all the cell between these two cells formatted with a red as well - can that be done?

e.g. with an IF statement saying if cell A21 is red and the current cell A22 isn't colored = True which will add the color it red to it which all true cells will be until and it gets that A44 and the current cell is red =false for the rest of the row.

Answer 1

You cannot check for a color of any cell for conditional formatting, but you can select an entire range of cells and perform the conditional formatting on all those cells based on the content of one cell rather than all using the =formula.

So you basically want to duplicate the formula for the first conditioned cell, and use that on the other cells to make them color as that single cell changes.

Do note that if a condition is not met, the cell's original color is still used. You can also use conditional formatting to color a cell white to make it seem a condition undo's formatting.