What I would like is: if ANY cell has a number greater than 1 - then the next 3 cells TO THE RIGHT trun red
Is there a way of doing this, without me having to type the formula in to every single cell?
Please help
What I would like is: if ANY cell has a number greater than 1 - then the next 3 cells TO THE RIGHT trun red
Is there a way of doing this, without me having to type the formula in to every single cell?
Please help
What @toryan said is correct. I would start by creating a conditional formatting rule that checks the three cells to the left of the active cell for a value greater than 1.
Then you can use format painter to quickly copy this rule to all of the other cells in the sheet. Select the cell in which you've placed the formula. Click the format painter on the home tab, and then select all of the cells in which you want the formula pasted.