Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color excel 2007
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color excel 2007
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. "pcor" wrote: 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Background color excel 2007
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- __________________________________ HTH Bob "pcor" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Should Allow Me to Change the Background Color | Excel Discussion (Misc queries) | |||
Background color in Excel 2007 | New Users to Excel | |||
Excel automatic background color | Excel Discussion (Misc queries) | |||
Excel 2003 Font Color and Background Color | Excel Discussion (Misc queries) | |||
Background color on Excel Spreadsheet | Excel Discussion (Misc queries) |