Background color excel 2007

  • Thread starter Thread starter pcor
  • Start date Start date
P

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
 
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.
 
Back
Top