-
If and checkbox
I have used th IF equation and the checkbox and I want it to copy a value from another cell when the checkbox is checked. Until here I am ok. However I want it to apply the number "0" (zero) when the check box is unchecked. can anybody help me please? Thank you.
-
% complete value not adjusting start date of next task
Hello I am hoping someone can help please, here is my problem I have a few tasks, dependent on each other - D is dependent on C, C is dependent on B, B is dependent on A etc etc. I have a complete tick box for them and also a % complete column Task A is complete, Task B is 40% complete, Task C is still showing it starting…
-
Very strange formatting issue
In my sheet, I keep my primary column font color "Red" until we take the first action. At that time I manually change the color to "Black". I do not have any conditional formatting that has any control over that column. I do have other columns that do have conditional formatting controlling them. Here is the strange part..…
-
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
-
Locking a row when a check box is selected
Is it possible to have a row "lock" when someone selects the "check box" column, so they (Editors) can not change data on that row?
-
Dates not lining up
My editorail calendar isn't lining up when I sort by date. My April dates are below July. I'm not sure what's happening with the formatting.
-
Conditional Formatting based on a cell text formatting
Hello hive mind. I am familiar with IF statements and Conditional Formatting, but I am not seeing a way with either of those for the followng. I would like to set a Conditional Formatting Rule to highlight a row to a certain color if the text in a particular cell is in bold. There does not seem to be a way with Cond. Form.…
-
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks…
-
Continuously moving inventory - keeping a record without overwriting current information
Hi there, We have an existing Inventory database in Excel that i have imported successfully. However now I need to figure out - if I can - how to 'track' the movements of any given piece of equipment. For example we have a Computer Monitors that are 'loaned' to customers every so often. I woud like to keep a 'log' of the…
-
Feature Request: Conditional formatting based on "or" statements (particularly "is blank")
The way the conditional formatting rules are currently written: 1. You can create condtions that are X or Y when X and Y are values that have already been filled in by click on both from the menu. 2. You can create chains of "and" statements based on various condtions such as "is blank" or "greater than" both when you…
