FareedAhmed76

Posts: n/a

How can I get a cell locked if the condition is false?

I am the user of MS office 2000, Here I am stuck with a function in Excel.
I would be grateful if helped.
I want a cell locked (that specified cell shell not accept any value) if a
condition is false.
Example: If the value in cell (B1) is equal to the value in cell (A1) then
the cell (C1) should accept a value.
And if the value in cell (B1) is not equal to the value in cell (A1) then
the cell (C1) should not accept any value.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In excel, I seem to be "locked" on a cell and unable to click off.	Bubba Junie	Excel Discussion (Misc queries)	7	May 1st 06 07:46 AM
How do I add a balloon message to a locked cell	kden01	Excel Discussion (Misc queries)	2	January 28th 05 06:49 PM
Problem with IF condition or vector lookup?	J-Philippe	Excel Worksheet Functions	4	January 15th 05 08:41 PM
make a cell empty based on condition	mpierre	Charts and Charting in Excel	2	December 29th 04 01:01 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us