Setting a Cells Background Value

%3CLINGO-SUB%20id%3D%22lingo-sub-2390169%22%20slang%3D%22en-US%22%3ESetting%20a%20Cells%20Background%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2390169%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20hoping%20someone%20can%20help%20as%20I'm%20going%20insane%20trying%20to%20work%20it%20out.%20Ill%20try%20and%20explain%20the%20best%20I%20can.%3C%2FP%3E%3CP%3EI%20want%20the%20Cells%20under%20Lots%20(the%20clear%20cells)%20to%20equal%20the%20value%20under%20column%20B%20%26amp%3B%20D.%20eg%20Line%203%20will%20equal%2019.3%20%26amp%3B%201.7%20across%20the%20entire%20lot%20section.%20I%20then%20want%20to%20be%20able%20to%20color%20a%20cell%20or%20enter%20a%20number%20between%201-350%20(preferably%20enter%20a%20number%20but%20color%20if%20easier)%20and%20it%20equal%20the%20value%20from%26nbsp%3Bcolumn%20B%20%26amp%3B%20D%20not%20the%20number%20in%20the%20cell.%20I%20want%20the%20averages%20at%20the%20bottom%20to%20match%20the%20ones%20that%20are%20either%20colored%20or%20numbered%20without%20needing%20the%20value%20to%20average.%20I%20want%20it%20to%20pull%20this%20info%20from%20B%20%26amp%3B%20D.%3C%2FP%3E%3CP%3EI've%20currently%20been%20entering%20the%20value%20it%20will%20average%20into%20the%20cell%2C%20I%20then%20make%20the%20clear%20area%20font%20color%20white%20and%20print%20the%20sheet%20so%20I%20can%20number%20them%20manually.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20information%20from%20Column%20B%20%26amp%3B%20D%20will%20change%20from%20time%20to%20time%20so%20I%20will%20need%20the%20cells%20to%20update%20the%20value%20automatically%20when%20I%20update%26nbsp%3BColumn%20B%20%26amp%3B%20D.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2390169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2391298%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20a%20Cells%20Background%20Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2391298%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064403%22%20target%3D%22_blank%22%3E%40EmmaLisa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20illustrate%20in%20your%20file%20what%20is%20desired%20result%20since%20it's%20not%20clear%20what%20is%20required%2C%20at%20least%20for%20me.%20For%20example%3C%2FP%3E%0A%3CP%3E%22%3CSPAN%3EI%20then%20want%20to%20be%20able%20to%20color%20a%20cell%20or%20enter%20a%20number%20between%201-350%20(preferably%20enter%20a%20number%20but%20color%20if%20easier)%22%20-%20which%20cell%2C%20what%20is%20the%20logic%20to%20use%20this%20or%20that%20color%20%2F%20number%3F%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%22and%20it%20equal%20the%20value%20from%26nbsp%3Bcolumn%20B%20%26amp%3B%20D%20not%20the%20number%20in%20the%20cell.%3C%2FSPAN%3E%22%20-%20'value'%20assumes%20one%20cell%2C%20not%20columns.%20What%20exactly%20shall%20be%20taken%20from%20B%20%26amp%3B%20D%20%3F%26nbsp%3B%20Do%20not%20number%20in%20which%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm hoping someone can help as I'm going insane trying to work it out. Ill try and explain the best I can.

I want the Cells under Lots (the clear cells) to equal the value under column B & D. eg Line 3 will equal 19.3 & 1.7 across the entire lot section. I then want to be able to color a cell or enter a number between 1-350 (preferably enter a number but color if easier) and it equal the value from column B & D not the number in the cell. I want the averages at the bottom to match the ones that are either colored or numbered without needing the value to average. I want it to pull this info from B & D.

I've currently been entering the value it will average into the cell, I then make the clear area font color white and print the sheet so I can number them manually. 

The information from Column B & D will change from time to time so I will need the cells to update the value automatically when I update Column B & D. 

1 Reply

@EmmaLisa 

Perhaps you may illustrate in your file what is desired result since it's not clear what is required, at least for me. For example

"I then want to be able to color a cell or enter a number between 1-350 (preferably enter a number but color if easier)" - which cell, what is the logic to use this or that color / number?

"and it equal the value from column B & D not the number in the cell." - 'value' assumes one cell, not columns. What exactly shall be taken from B & D ?  Do not number in which cell?