ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can not select conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/21326-can-not-select-conditional-formatting.html)

gbeard

can not select conditional formatting
 
I formatted a cell with a conditional format and now I can not select
conditional formatting, nor can I paste the conditional format of that cell
to other cells.

any ideas?

--
Gary Beard



Kassie

Have you since protected or shared the worksheet? In neither instance will
you be able to change conditional formatting


"gbeard" wrote:

I formatted a cell with a conditional format and now I can not select
conditional formatting, nor can I paste the conditional format of that cell
to other cells.

any ideas?

--
Gary Beard




gbeard

I have not protected or shared the worksheet. I simply tested the
conditional formatting on a single cell and when I couldn't paste it to the
other cells I wanted to I tried selecting conditional formatting from the
menu and it was grayed out.

Thanks for the reply Kassy

--
Gary Beard




All times are GMT +1. The time now is 10:24 PM.

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