Conditional formatting

**sushil10s** · 11-03-2011, 05:55 AM

Hi

Conditional formatting is not highlighted, i.e, it is not working (dead).

What may be the cause and how to enable that button?

Thanks
Sushil

**Andrew-R** · 11-03-2011, 05:58 AM

Is the sheet you're working on protected?

**sushil10s** · 11-03-2011, 06:00 AM

Hi

it's not protected. Yesterday I was taking help of conditional formatiing with the data. Don't know what happened?

Sushil

**romperstomper** · 11-03-2011, 06:01 AM

Is the workbook shared? Do you have more than one sheet selected?

**sushil10s** · 11-03-2011, 06:04 AM

Its not shared even...and I want to delete extra sheets, delete option is also disabled when I right click on extra sheets.

**romperstomper** · 11-03-2011, 06:05 AM

Probably need to see the workbook then.

**sushil10s** · 11-03-2011, 06:21 AM

Here it is.......

**romperstomper** · 11-03-2011, 06:30 AM

Your workbook is Shared (it says so in the title bar). Unshare it and you will be fine.

**sushil10s** · 11-03-2011, 06:41 AM

Solved

thanks

**romperstomper** · 11-03-2011, 06:44 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save