LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Block a cell depending on the sum of other cells

Hi,
I want to be able to block a cell if the sum of other cells are <0
Example:

If Sum(A1:A5)<0 then block A6
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
directing the sum of a cell to either of two cells depending on va Debi Excel Discussion (Misc queries) 3 April 15th 10 09:49 AM
block of cells appear as single cell John Grandy New Users to Excel 2 April 1st 10 03:24 PM
fill any random cell in a column and block all other cells SK Excel Discussion (Misc queries) 5 October 12th 09 07:20 PM
Unprotect Cells depending on Cell value Abes Excel Worksheet Functions 2 August 24th 05 10:03 AM
Copying block (range of cells) based on a value of a specific cell-VBA Branimir Excel Programming 1 October 15th 03 06:07 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"