Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
color code cells based on golddigger formula
Okay, I am using Excel to manage my dating life. I would like to color
code desirable dates green, iffy ones yellow, and ones to avoid, red Here is my formula: golddigger ratio % = (cost of date/reaction of the date) x 2 Reaction of date is from 1 to 5 with 1 being date was very dissatisfied, and 5 being extremely happy. So assume I shell out 50 bux on a date (50 is my monthly dating budget) and date is a 1 on the happiness scale: (50/1)*2 = 100% There is a 100% probability my date was a golddigger 40 dollars and a 2 on the happiness scale = (40/2) * 2= 40% chance of date being a golddigger. 5 dollars on date and 5 on happiness scale = (5/5)*2 = 2% chance of being golddigger NOW hereis what I'd like to do: Color cells, green, yellow, or red 0-33% Want cell colored Green 34-66% Yellow 67%-100% Red Esentially, I want to color code things to make selection process easier. Do I need a macro for this? Thanks in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
color code cells based on golddigger formula
Being an Excel developer & a person who pays exorbitant child support, I feel
in the best position to answer this question You can use conditional formatting under the format menu. Check out LiarWife.com while your at it. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Network Guru" wrote: Okay, I am using Excel to manage my dating life. I would like to color code desirable dates green, iffy ones yellow, and ones to avoid, red Here is my formula: golddigger ratio % = (cost of date/reaction of the date) x 2 Reaction of date is from 1 to 5 with 1 being date was very dissatisfied, and 5 being extremely happy. So assume I shell out 50 bux on a date (50 is my monthly dating budget) and date is a 1 on the happiness scale: (50/1)*2 = 100% There is a 100% probability my date was a golddigger 40 dollars and a 2 on the happiness scale = (40/2) * 2= 40% chance of date being a golddigger. 5 dollars on date and 5 on happiness scale = (5/5)*2 = 2% chance of being golddigger NOW hereis what I'd like to do: Color cells, green, yellow, or red 0-33% Want cell colored Green 34-66% Yellow 67%-100% Red Esentially, I want to color code things to make selection process easier. Do I need a macro for this? Thanks in advance for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
color code cells based on golddigger formula
thanks for the info on conditional format , and your blog is interesting.
I'll stay single after reading all this. http://mirrorofthesoul.blogspot.com/ another blog you may find interesting. I got my golddigger formula from a posting this man made on another board. after reading this blog and your blog, i will stay single. "galimi" wrote in message ... Being an Excel developer & a person who pays exorbitant child support, I feel in the best position to answer this question You can use conditional formatting under the format menu. Check out LiarWife.com while your at it. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Network Guru" wrote: Okay, I am using Excel to manage my dating life. I would like to color code desirable dates green, iffy ones yellow, and ones to avoid, red Here is my formula: golddigger ratio % = (cost of date/reaction of the date) x 2 Reaction of date is from 1 to 5 with 1 being date was very dissatisfied, and 5 being extremely happy. So assume I shell out 50 bux on a date (50 is my monthly dating budget) and date is a 1 on the happiness scale: (50/1)*2 = 100% There is a 100% probability my date was a golddigger 40 dollars and a 2 on the happiness scale = (40/2) * 2= 40% chance of date being a golddigger. 5 dollars on date and 5 on happiness scale = (5/5)*2 = 2% chance of being golddigger NOW hereis what I'd like to do: Color cells, green, yellow, or red 0-33% Want cell colored Green 34-66% Yellow 67%-100% Red Esentially, I want to color code things to make selection process easier. Do I need a macro for this? Thanks in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
color fill cells based on IF function or formula | Excel Worksheet Functions | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Coloured cells based on formula | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |