ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Format to Highlight the Active Cell (https://www.excelbanter.com/excel-worksheet-functions/196969-conditional-format-highlight-active-cell.html)

Pawprint

Conditional Format to Highlight the Active Cell
 
I have created a protected sheet with a few pre-populated, unlocked data
entry cells. Is there a way to create a Conditional Format to "highlight" the
activecell that the user is on? I cannot use VB since the sheet will be used
on secured systems and the macro will be blocked.



Jim Thomlinson

Conditional Format to Highlight the Active Cell
 
Nope... Chip pearson has an addin that does what you want. Addins don't tend
to be blocked so long as you have the authority to install the addin...

http://www.cpearson.com/excel/RowLiner.htm
--
HTH...

Jim Thomlinson


"Pawprint" wrote:

I have created a protected sheet with a few pre-populated, unlocked data
entry cells. Is there a way to create a Conditional Format to "highlight" the
activecell that the user is on? I cannot use VB since the sheet will be used
on secured systems and the macro will be blocked.




All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com