Data in cell changes then another cell data to change

J

Jennifer1960

Need help to write formula or suggest a way of doing.

When Cell F3 is not equal to "CURRENT"
then where (G3:G10) contains X
change X to A.
 
D

davesexcel

Jennifer1960 said:
Need help to write formula or suggest a way of doing.

When Cell F3 is not equal to "CURRENT"
then where (G3:G10) contains X
change X to A.if there are only 7 rows, maybe this could work,enter this formula in
Click to expand...
each of the cells G3:G10
=if($F$3="CURRENT","A","X")

or maybe you need this in each cell

=IF(F3="CURRENT","A","X")
=IF(F4="CURRENT","A","X")
=IF(F5="CURRENT","A","X")
=IF(F6="CURRENT","A","X")
=IF(F7="CURRENT","A","X")
=IF(F8="CURRENT","A","X")
=IF(F9="CURRENT","A","X")
=IF(F10="CURRENT","A","X")
 
J

Jennifer1960

Dave thansk but it did not work

I need G3:G10 that contains X to change to A when F3 does NOT = "Current".

Jennifer
 
M

Muhammed Rafeek M

use this macri in your particular sheet module:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Dim i As Integer
If Target.Address = "$F$3" And UCase(Target.Value) <> "CURRENT" Then
For i = 3 To 10
If UCase(Range("G" & i).Value) = "X" Then Range("G" & i).Value =
"A"
Next i
End If
End Sub


Jennifer1960 said:
Dave thansk but it did not work

I need G3:G10 that contains X to change to A when F3 does NOT = "Current".

Jennifer
Click to expand...
 
Top