| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
Linear Mode
