Conditional formatting from another cell's value ...

%3CLINGO-SUB%20id%3D%22lingo-sub-1131957%22%20slang%3D%22en-US%22%3EConditional%20formatting%20from%20another%20cell's%20value%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131957%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20format%20a%20cell%20based%20on%20another%20cell's%20value%20but%20I%20already%20have%20a%20formula%20in%20place%20to%20count%20the%20age%20of%20an%20entry%20in%20days%20-%26nbsp%3Bie.%2C%20%3DDAYS(TODAY()%2CC2).%20When%20the%20age%20is%20%26gt%3B20%20days%20it%20turns%20the%20cell%20red.%20Now%20I%20have%20another%20cell%20on%20the%20same%20row%20that%20when%20an%20action%20has%20been%20taken%20and%20the%20value%20is%20changed%20to%20an%20X%20and%20that%20cell%20turns%20green%2C%20I%20need%20my%20original%20cell%20that%20has%20the%20age%20formula%20in%20it%20to%20turn%20green%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1131957%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1131974%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20from%20another%20cell's%20value%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F534960%22%20target%3D%22_blank%22%3E%40SneadTractor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20put%20%22green%22%20rule%20on%20the%20top%20and%20and%20check%20its%20%22Stop%20if%20true%22%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to format a cell based on another cell's value but I already have a formula in place to count the age of an entry in days - ie., =DAYS(TODAY(),C2). When the age is >20 days it turns the cell red. Now I have another cell on the same row that when an action has been taken and the value is changed to an X and that cell turns green, I need my original cell that has the age formula in it to turn green as well.

1 Reply

@SneadTractor 

You may put "green" rule on the top and and check its "Stop if true" box.