Oboji ceo red u kome se trenutno nalazi kursor

27/06/2013 § Leave a comment

Odabrati ceo red 1
Formulas
Name Manager
ActiveRow =1

Excel_CF002

Selektovati ceo sheet (polje izmedju A i 1)
Conditional Formatting
Use a formula to determine which cells to format
=row(A1)=ActiveRow
Izabrati boju kojom će red biti obojen
Kopirati makro
This Sheet
Option Explicit
Private Sub Worksheet_SelectionChange (ByVal Target As Range)
with ThisWorkbook.Names(“ActiveRow”)
.Name = “ActiveRow”
.RefersToR1C1 = “=” & ActiveCell.Row
End With
End Sub


Source:

http://chandoo.org/wp/2012/07/11/highlight-row-column-of-selected-cell-using-vba/
Download excel example:highlight-row-column-demo


http://www.msofficegurus.com/post/Excel-Highlight-the-Active-Cell.aspx

Color Palette:
http://dmcritchie.mvps.org/excel/colors.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Oboji ceo red u kome se trenutno nalazi kursor at RheXenoR.

meta

%d bloggers like this: