IF Statements

%3CLINGO-SUB%20id%3D%22lingo-sub-2106783%22%20slang%3D%22en-US%22%3EIF%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106783%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20one%20will%20be%20easy%20for%20you%20experts!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20cell%20that%20works%20so%20that%20if%20the%20value%20is%20the%20same%20as%20another%20cell%20(C9%20in%20this%20case)%20it%20colors%20green%20and%20if%20it%20does%20not%20it%20colors%20red.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20do%20this%20myself%20it%20just%20gives%20me%20the%20word%20Green%20or%20the%20word%20Red.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

This one will be easy for you experts!

 

I need to create a cell that works so that if the value is the same as another cell (C9 in this case) it colors green and if it does not it colors red. 

When I do this myself it just gives me the word Green or the word Red.

Thanks!

1 Reply

@GeorgeMitch380 You need to do this with Conditional Formatting. Example attached.

More about that in the link below:

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...