Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Arnold Scott on Aug 25 In MS Office Category.

get cell loc from range

Question Answered By: Angie Bennett on Aug 25

You dont need VBA for this. Conditional formatting of cell B1: choose
'Formula is:' and enter this:

=B1=MAX(B$1:B$5)

and set how you want it to be highlighted. Then using the Format
Painter icon on the Standard Toolbar, copy to B2:B5.

This Question has 1 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on get cell loc from range Or get search suggestion and latest updates.

Related Topics:

Copying current cell's value to another cell
copy a range of cells to another sheet
Dynamic cell range
apply function for range of column cells
Getting error "Subscript out of range" Runtime error "9"
Getting a range of values
highlight a range using a named range
getting the sum of the last 20 cells
Function needed to split the content of a cell into many cells
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
A Paragraphs in one cells --> convert into a line in per cells
Cell validation based on the contents of previous cell
Copy cell contents to same cell on different worksheet if contains
Moving data in the last cell of row to another column cell
how are cell coordinates referenced on a clicked cell

Tagged:get cell loc from range

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us