| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
No matter what I try, I cannot get the Conditional Formatting function to
work on any cell in my workbook. Any ideas what could be causing this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Hi,
Do you have an example of formula which is not working ...? Carim |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Can't even get to that point. I click on "Format", and one of the options to
use is Conditional Formatting, but the button is not active. "Carim" wrote: Hi, Do you have an example of formula which is not working ...? Carim |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Tools Protection UnprotectSheet..........
Vaya con Dios, Chuck, CABGx3 "daninky" wrote: Can't even get to that point. I click on "Format", and one of the options to use is Conditional Formatting, but the button is not active. "Carim" wrote: Hi, Do you have an example of formula which is not working ...? Carim |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Hi,
Use VBA for following instruction : Application.CommandBars("Format").Controls("Condit ional Formatting").Enabled = True HTH Carim |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Thanks, but no good... doesn't give me the Unprotect Sheet option...
"CLR" wrote: Tools Protection UnprotectSheet.......... Vaya con Dios, Chuck, CABGx3 "daninky" wrote: Can't even get to that point. I click on "Format", and one of the options to use is Conditional Formatting, but the button is not active. "Carim" wrote: Hi, Do you have an example of formula which is not working ...? Carim |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
How about ToolsShare Workbook?
De-select the "allow changes etc." option. Gord Dibben MS Excel MVP On Fri, 13 Oct 2006 09:59:01 -0700, daninky wrote: Thanks, but no good... doesn't give me the Unprotect Sheet option... "CLR" wrote: Tools Protection UnprotectSheet.......... Vaya con Dios, Chuck, CABGx3 "daninky" wrote: Can't even get to that point. I click on "Format", and one of the options to use is Conditional Formatting, but the button is not active. "Carim" wrote: Hi, Do you have an example of formula which is not working ...? Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
