Changing the contents of a cell based on the cell above

[Jon_Clay]

Hello everyone

I need to make the contents of a cell a certain value if the cell below (on the next row) is a certain value.

So, in this case, if a cell contains the number 3 then I need to make the next cell down to be number 3 as well. I'm sure this is possible using Conditional Formatting, but I can't seem to get it to work.

Any help would be much appreciated.

Thank you
Jon

[TMS]

Conditional Formatting does what it says on the tin ... changes the formatting dependant on one or more conditions. You can't change a cell's value.

You'll probably need VBA for this task ... unless there is a formula in the cell that can be adapted.

[GeoffW283]

I may be misunderstanding your requirement, but just in case I'm not:

From your example, let's say the cell possibly containing 3 is cell A1. The cell below is A2. What do you want cell A2 to be if cell A1 does NOT contain 3? Here, for the formula in cell A2 I have assumed cell A2 should be blank if cell A1 is anything other than 3
In A2: =IF(A1=3, 3, "")