Number in a cell based on a colour in another cell

[tenbellies]

Hi,

Is there any way to have a numeric value in a cell based on a colour in another...

For example if cell A1 is green the text in cell A2 would say 100%

I cant use macro's or VBA the system I have to use does not allow any macro's/VBA - system is locked down to prevent this

 

[tenbellies]

Worked it out =if(cell("format"="G","100%",0)

 

[Special-K99]

If the cell has been coloured using Condtional Formatting then just use the same conditions to set the cell value to 100%.
If the cell has been coloured manually your only solution is VBA, formulas cannot determine the colour of a cell.

 

[Special-K99]

Worked it out =if(cell("format"="G","100%",0)

That's G for General, the format of the VALUE of that cell is General format, nothing to do with colour.
Change the colour of the cell text to something other than green.
Your cell value will still say 100% so the formula is not picking up the colour of the text (as stated above).

 

[tenbellies]

Unfortunately you are correct -