Conditional Formatting Help-rules for a grade sheet.

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
>
>