Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting and If function?
Can this be done? I want the value of cell g4 to depend on the text entry to cell f4 If f4 = a then g4 displays 25% value of cell c4 If f4 = b then g4 displays 50% value of cell c4 If f4 = c then g4 displays 75% value of cell c4 If f4 = d then g4 displays 100% value of cell c4 Can this be done? -- dond ------------------------------------------------------------------------ dond's Profile: http://www.excelforum.com/member.php...o&userid=25477 View this thread: http://www.excelforum.com/showthread...hreadid=389300 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting "OR" function | Excel Worksheet Functions |