Conditional Formatting on Multiple Cells

It is better to "use a formula" in setting the CF conditions, as you have more control over what is happening. In this case I would suggest that you select all the cells with an existing CF rule (assume this to be from A3 to E_whatever), click on CF, and then Delete existing rules from the selected cells. Then, with them still selected, click on CF | New Rule | Use a formula..., and put this formula in the dialogue box:

=$E3=1

Then click the Format button and Fill tab and choose Green, then OK your way out. Excel will adjust the cell references in the formula to suit the cells that were selected, so in this case the column (E) will remain unchanged, but the row number (3) will change for cells on other rows.

Hope this helps.

Pete

Thank you Pete_UK! That worked GREAT!!! The only issue is that I am having to do each row individually, as I already have CF in other cells. Is there a way to do the formula on a range of cells instead???

Originally Posted by dgaletar

Thank you Pete_UK! That worked GREAT!!! The only issue is that I am having to do each row individually, as I already have CF in other cells. Is there a way to do the formula on a range of cells instead???

Click on cell A3, then Conditional Formatting | Manage Rules and then you should see the rule that you have set up and in the Applies to box you can see the range this applies to (it might just be A3 to E3). You can adjust this range e.g. to A3:E100, and then click OK.

Hope this helps.

Pete

Hey there Pete_UK, I tried changing the range like you suggested, but when the first row changed, all of the rows changed.

Your thoughts Sir...

I can set up the individual range, but no additional rows. :-(

Re: Conditional Formatting on Multiple Cells
Can you set up the range for that when yo create the rule?

I can set up the individual range, but no additional rows. :-(