Background color excel 2007

[pcor]

I would like to know how to procedd to obtain the following results:
if F8 background color=CYAN then k8=j6 other wise nothing happens.
Thanks

 

[Ron@Buy]

Please explain further:
Are you changing the color manually in F8 ?
Which cell takes precedence K8 or J6 ? i.e in which cell is the data entered?
You can't make actions occur in Excel by changing the color of the cell
unless you write a macro.
Perhaps a simple solution may be to insert a helper column (it can be narrow
and with a small font number & color to make it unobtrusive), say E. Then
using Conditional formatting in F8 enter Formula =E8=1 and format fill to
Cyan. Now when you enter a 1 in E8, F8 will change color to cyan. Now in say
K8 enter the formula:
=IF(E8=1,J6,"")
Hope this helps.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution