Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel help - Is there a way to
Looking at the chart below, is there a way to limit what is entered in the
"Actual" column E.g. in cell B2 10% has been entered in cell B3 I want to limit it so the max you can enter is 90% in cell B4 I want to limit it so the max you can enter is 80% And so on Target Actual 10% 10% 20% 10% 30% 40% 50% 60% 70% 80% 90% 100% Thanking you in advance Derek |