=IF (CELL iS Highlighted) then...

[TOKYOJ1]

Is there a formula based on highlighted cells?

Example
If cell A1 is highlighted in any color, then B1=100

Many thanks!

 

[Fluff]

Is A1 highlighted manually or via conditional formatting?

 

[TOKYOJ1]

Manually..

 

[Special-K99]

Then you have to use VBA though I can't tell you how to do that.

 

[Fluff]

In that case it cannot be done by xl formulae.

Whilst it can be done otherways it will not be automatic.

 

[Fluff]

One option, without VBA, but the workbook needs to be saved as an xlsm macro enabled book.

On the formulas tab > Name Manager > New > in Name put IsColoured > in refers to put =GET.CELL(63,INDIRECT("rc[-1]",FALSE)) > ok

Then in B1 put =IF(IsColoured,100,"")
Every time you highlight A1 you will need to re calculate the sheet for the formula to work