HELP PLEASE!!! How to delete applied format after navagating to different row

[photonicman]

I want to have the macro delete the color applied once a new "Row" is selected!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim RR As Range
Set RR = Target

Cells(RR.Row, 2).Interior.ColorIndex = 36
Cells(RR.Row, 3).Interior.ColorIndex = 36
Cells(RR.Row, 4).Interior.ColorIndex = 36

End Sub

 

[pgc01]

Only want the minutes

If you want the minutes as a number you can use

=MINUTE(A1)

If you want the minutes as time you can use

=MINUTE(A1)/1440

and format the cell as time, ex.: hh:mm

If you want to use the function Text() then besides the minutes you have to specify either the hours or seconds. Ex:

=RIGHT(TEXT(A1,"h:mm"),2)

The problem is that the "m" in the format string can be either month or minute and in case of doubt excel chooses month. That's why you were getting the result 1. If you specify next to the minutes either the hours or the seconds there's no longer doubt that you really want minutes.