I am wanting to know how I can keep my previous to conditioning formats in excell while adding another without it deleting my previous two. Let me explain. I have two conditional formatings. For your reference if it helps, Condition 1 says: Formula Is... =AND(C3-TODAY()<=0) this is set to change to red. Condition 2 says: Formula Is... =AND(C3-TODAY()<=7) this is set to change to blue.
My question is... I want to set up another condition formula and basically I want this formula to be a "Strikethrough" without this formula deleting my other two formulas mentioned previously. When my balance reaches zero I want excel to automatically put a Strikethrough to help me keep track of what is closed out and what is still open. Someone was already kind enought to provide me the correct formula to do the Strikethrough when my balance reaches zero but my next problme is how to combine multiple conditions without erasing what I have already entered in. Any help on this would be greatly appreciated!
My question is... I want to set up another condition formula and basically I want this formula to be a "Strikethrough" without this formula deleting my other two formulas mentioned previously. When my balance reaches zero I want excel to automatically put a Strikethrough to help me keep track of what is closed out and what is still open. Someone was already kind enought to provide me the correct formula to do the Strikethrough when my balance reaches zero but my next problme is how to combine multiple conditions without erasing what I have already entered in. Any help on this would be greatly appreciated!