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

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

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