Data in cell changes then another cell data to change
 

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.

Data in cell changes then another cell data to change
 

Jennifer1960 Wrote:
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
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")


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574452

Data in cell changes then another cell data to change
 

Dave thansk but it did not work

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

Jennifer

"davesexcel" wrote:


Jennifer1960 Wrote:
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
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")


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574452

Data in cell changes then another cell data to change
 

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" wrote:

Dave thansk but it did not work

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

Jennifer

"davesexcel" wrote:


Jennifer1960 Wrote:
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
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")


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574452