ExcelBanter - Conditional Formatting Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting Help (https://www.excelbanter.com/excel-discussion-misc-queries/43235-conditional-formatting-help.html)

Conditional Formatting Help

If cell c6 says: ---------------------------- I would like to
have D6 automatically say

Approved ---------------------------- 25%
or
Design ---------------------------- 50%
or
Build ---------------------------- 75%
or
Shipped ---------------------------- 100%

Any Ideas????

Thanks

John

--
John Doe
------------------------------------------------------------------------
John Doe's Profile: http://www.excelforum.com/member.php...o&userid=26826
View this thread: http://www.excelforum.com/showthread...hreadid=400756

Try this:

=IF(C6=0.25,"Approved",IF(C6=0.5,"Design",IF(C6=0. 75,"Build",IF(C6=1,"Shipped",""))))

"John Doe" wrote:

If cell c6 says: ---------------------------- I would like to
have D6 automatically say

Approved ---------------------------- 25%
or
Design ---------------------------- 50%
or
Build ---------------------------- 75%
or
Shipped ---------------------------- 100%

Any Ideas????

Thanks

John

--
John Doe
------------------------------------------------------------------------
John Doe's Profile: http://www.excelforum.com/member.php...o&userid=26826
View this thread: http://www.excelforum.com/showthread...hreadid=400756