ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   conditional formating (https://www.excelbanter.com/excel-programming/420412-conditional-formating.html)

basilio

conditional formating
 
how can I check the conditional format of a cell and use the result to modify
another cell format ? Up to now I have to use again the same condition.
Excel helps only with negative values, etc.

Basilio

OssieMac

conditional formating
 
Try Copy - Paste Special - Formats

--
Regards,

OssieMac


"basilio" wrote:

how can I check the conditional format of a cell and use the result to modify
another cell format ? Up to now I have to use again the same condition.
Excel helps only with negative values, etc.

Basilio


franciz

conditional formating
 
to check which cells in your spreadsheet have conditional formatting, use
Menu bar's Edit GoTo Special check Conditional Formats, this will
shown you all the highlighted cells that contains conditional formats.

hope this is what you are looking for.
click on yes if this help.

thanks

"basilio" wrote:

how can I check the conditional format of a cell and use the result to modify
another cell format ? Up to now I have to use again the same condition.
Excel helps only with negative values, etc.

Basilio



All times are GMT +1. The time now is 08:51 AM.

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