Formula needed to populate cell with same value.

[RodneyW]

If G8 is populated with x, I need K8, O8, S8, W8 and AA8 each to populate with x. I also need to be able to drag the formula down to rows 9, 10, etc. Thank you in advance

 

[Fluff]

Simply put this in each of those cells
=IF(G8="x",G8,"")

 

[PurrSent]

Hi

I'm no expert but, having had a lot of help on this forum, would like to be able to help others where (I think) I can

Type "=K8" into each of the cells you want to show the same value, then drag down the column using the '+' on lower right corner

Good luck

Oops! Looks like I may have misunderstood the question! Suggest Fluff has better experience than I have

 

[RodneyW]

Fluff, thanks for your reply. The formula works exactly as intended however after applying it, I realized there's an element I hadn't considered. I can't have a formula in cells K8, etc. because if G8 does not = x, users need to be able to enter a value in K8, etc. Can Conditional Formatting or something else be applied here? I've tried that and can't get it to work.

 

[Fluff]

Nope, conditional formatting only affects the format, not the actual value in the cell.
You would need VBA

 

[Joe4]

A cell can either have a formula or a value in it, but never both at the same time.
What you want to do would require VBA.

Right-click on the sheet tab name at the bottom of your screen, select "View Code", and paste this code in the resulting VB Editor window, and this will do what you want.

Private Sub Worksheet_Change(ByVal Target As Range)

'   See if cell G8 was updated
    If Not Intersect(Target, Range("G8")) Is Nothing Then
'       See if cell G8 was set to "X"
        If Range("G8") = "X" Then
'           Populate other cells with values of cell G8
            Application.EnableEvents = False
            Range("K8,O8,S8,W8,AA8").Value = Range("G8").Value
            Application.EnableEvents = True
        End If
    End If
    
End Sub

 

[RodneyW]

Thanks. I'll see if I can get that to work