ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to apply same format of referenced cell in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/110943-how-apply-same-format-referenced-cell-excel.html)

Steven Brassem

How to apply same format of referenced cell in Excel
 
Would wish to use more than the maximum of 3 (extendable to a virtual 4...)
conditions for conditional formatting for buidling a certain application.
Application needs to change the color of a cell, based on its value (need to
use at least some 10 different colors). It would be handy by using a drop
down list, to use the formats of the cells in the drop-down list, but this
doesn't work, of course. Is there alternatively a way of referencing to a
cell and get the format of that cell referenced to in the cell referencing
out? I am an experienced/advanced user but can't find a way around this.


All times are GMT +1. The time now is 12:29 PM.

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