ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional formatting grayed out? (https://www.excelbanter.com/excel-discussion-misc-queries/91833-conditional-formatting-grayed-out.html)

wolfpack95

Conditional formatting grayed out?
 

I am using a shared workbook and wanted to conditionally format blank
entries however the option is grayed out. Has a user restricted this
access or is there something else preventing this? Thanks in advance
for any help.


--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile: http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=547824


Ken Johnson

Conditional formatting grayed out?
 
Hi,

Changes to conditional formatting are not possible with a shared
workbook.

Ken Johnson


wolfpack95

Conditional formatting grayed out?
 

Thanks for the quick reply.


--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile: http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=547824


Bob Phillips

Conditional formatting grayed out?
 
Take a look at Limitations of a shared workbook in Help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wolfpack95" wrote
in message ...

I am using a shared workbook and wanted to conditionally format blank
entries however the option is grayed out. Has a user restricted this
access or is there something else preventing this? Thanks in advance
for any help.


--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile:

http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=547824





All times are GMT +1. The time now is 06:26 AM.

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