Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 504
Default "Conditional Formating" function grayed out

As pointed out in my subject, I can not use the conditional formating on my
tables. Please help.

--
Thanks a lot!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 504
Default "Conditional Formating" function grayed out

BTW, the worksheet seems "locked" or 'protected" since I can still use the
function on the new tables, anyway to confirm or remove this protection?
--
Thanks a lot!


"Kevin" wrote:

As pointed out in my subject, I can not use the conditional formating on my
tables. Please help.

--
Thanks a lot!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default "Conditional Formating" function grayed out

Is the worksheet protected? Unprotect it.

Is the workbook shared? Unshare it.


Gord Dibben MS Excel MVP

On Fri, 29 May 2009 14:16:02 -0700, Kevin
wrote:

As pointed out in my subject, I can not use the conditional formating on my
tables. Please help.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text "comparison" operator for "contains" used in an "IF" Function Pawaso Excel Worksheet Functions 4 April 4th 23 11:35 AM
Excel 2003: Conditional Formatting using "MIN" & "MAX" function MMangen Excel Discussion (Misc queries) 2 September 16th 08 07:13 PM
Conditional Formatting option "Grayed Out" jklpebbles Excel Worksheet Functions 2 November 30th 07 07:34 PM
Why is the "zoom" option grayed out in "print preview?" sschreiber Excel Discussion (Misc queries) 0 November 29th 07 04:42 PM
inserting a conditional "go to" command on a excel "if" function velasques Excel Worksheet Functions 5 March 10th 06 08:16 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"