Conditional formatting with indirect colors formating

[lsmoes]

Hi
I need help here.
I want to conditional format a range, depending on the value of the cell -> all clear here... I can do this easily

-> what I want though is instead of formating the cells with a fixed format (color specifically) I want to use colors that can be variable...

-->>> eg cell B1 should be formatted (following a conditional rule - eg B1 > C1) filled with the color that is in D1


With that the users can dynamically change the color schemes in D1:.... and it updates accordingly.#
PS: I do have VBA function that reads the background color of the cell in D1... so that the number could be used

How can then I use an indirect link to a color for formating

Thanks!

 

[Joe4]

Excel formulas (and formulas that are used in Conditional Formatting) can only run off of cell values, not their formatting.
I believe to do what you want would require the use of VBA.

If you are looking for some sort of automated VBA code, an Event Procedure is probably what you would use here. The main ones are:
Worksheet_Change - runs whenever a cell is manually updated
Worksheet_SelectionChange - runs whenever a cell is selected
Worksheet_Calculate - runs whenever any cell on the sheet is re-calculated (i.e. due to a change from a formula calculation)

If you need help setting this up, please provide specific details on how you would like this to work, i.e. what cells are being updated, how they are being updated, what cells they affect, when the code should be triggered to run.