Row and Columns (Excel Problem)

[Adeawan]

Assalam-o-Alaikum, Doston mujhe Excel 2002 mai aik Masla Darpesh hai... Main chahta hun k Jab mai Kissi Box mai kaam kar raha hun to us ki Row Highlight ho jaye taake k mujhe Entry Pass karnay mai Asaani ho.... Kindly es hawalay se Help kijiye....

Regards

Adeawan

[shahzebawan]

mery khayal say jab be ap kisi row per kaam karain tou uss ko background colour day dein

jab kaam khatam ho jay tou background colour khatam kar dein simple....

hope sahid ap ki kuch madad ho jay ge

[meerirfan]

Assalam-o-Alaikum, Doston mujhe Excel 2002 mai aik Masla Darpesh hai... Main chahta hun k Jab mai Kissi Box mai kaam kar raha hun to us ki Row Highlight ho jaye taake k mujhe Entry Pass karnay mai Asaani ho.... Kindly es hawalay se Help kijiye....

Regards

Adeawan

haan jee mujay bi iss ki zarrot hai kisi kay pass koi hal hai to batay. or eik or problem hai. for example agar main sheet1 per kaam kar raha hoon to wahi kaam automatically sheet2 main bi hoo jay iss kay liya koi formula hai too please share kareen .

best regards,

[Adeawan]

haan jee mujay bi iss ki zarrot hai kisi kay pass koi hal hai to batay. or eik or problem hai. for example agar main sheet1 per kaam kar raha hoon to wahi kaam automatically sheet2 main bi hoo jay iss kay liya koi formula hai too please share kareen .

best regards,

hmmm Sir, pehlay aik problem to solve ho jaye

Koi Expart jawab de sakta hai...???

[ismailshadab]

"Conditional formating" ............main......check karain.........
aus main........mumkin hai.........

[Adeawan]

"Conditional formating" ............main......check karain.........
aus main........mumkin hai.........

Sir us mai main try kar chukka hun... woh to Perminent Hight kar deta hai... aur mai chahta hun Jis Row par mai kaam kar raha hun Srif woh Highlight ho... es ka koi Solution batayen Pls

[ch_ttayyab]

Adeawan Bhai app ne Ms Office ka new version try kr k dekha hai

[Adeawan]

Adeawan Bhai app ne Ms Office ka new version try kr k dekha hai

Nahi Brother,,, main MS 2002 Use kar raha hun...

[ch_ttayyab]

Tu Bahi jaan
app Ms office 2003 Use kar ka dikine i hope app ki problm solve ho jaye gii keu ka old version ma asye feature nahi hotye.

[Adeawan]

Tu Bahi jaan
app Ms office 2003 Use kar ka dikine i hope app ki problm solve ho jaye gii keu ka old version ma asye feature nahi hotye.

Bahi,,, agar aap use kar rahay hain to Kindly check karain.... agar mumkin hai to bata dijiye.... warna meri Installation ki mehnat zayaan Jaye gi

[Silver Eyes]

ye lo apke masly ka hal....
1. excel open karen
2. Alt+F11 press karen to open VBE
3. ab right sight par nazar ane wali sheet1 par double click karen
4. ab ek windows open hu gi jis mein ap nichy dia hua code copy paste kar den.
5. Alt+Q press kar k VBE close kar den.....ab check karen apka kam hu chuka hai.


Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim RngRow As Range
Dim RngCol As Range
Dim RngFinal As Range
Dim Row As Long
Dim Col As Long

Cells.Interior.ColorIndex = xlNone

Row = Target.Row
Col = Target.Column

Set RngRow = Range("A" & Row, Target)
Set RngCol = Range(Cells(1, Col), Target)
Set RngFinal = Union(RngRow, RngCol)

RngFinal.Interior.ColorIndex = 6

End Sub

[Silver Eyes]

masla hal hua ya nahi