Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with function involving if then else?
Okay here's the problem. I want to take a percentage from two cells say a1 divided by b1, and if that is 10% I want it a color say yellow, then if it's 25% orange, and 50% or more red... now I can do any one of these individually, but for some reason my brain can't lock around the concept of doing three different ones depending on what I get? What am I missing here, I cant' seem to put the formula together in my brain. Any help would be appreciated.... --John -- jbobzien ------------------------------------------------------------------------ jbobzien's Profile: http://www.excelforum.com/member.php...o&userid=31696 View this thread: http://www.excelforum.com/showthread...hreadid=562343 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with function involving if then else?
Look at formats _ conditional formating If the percentage is in a cell condition 1 cell value is greater than or equal to 0.5 format cell as red add condition 2 cell value is greater than or equal to 0.25 format cell as orange add condition 3 cell value is greater than or equal to 0.1 format cell as yellow Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=562343 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with function involving if then else?
I forgot all about the conditional formatting option. I guess by not figuring it out, it was my brain's way of saying there's an easier way of doing this!!!! haha I appreciate it! -- jbobzien ------------------------------------------------------------------------ jbobzien's Profile: http://www.excelforum.com/member.php...o&userid=31696 View this thread: http://www.excelforum.com/showthread...hreadid=562343 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |