Help with Calculated columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1123501%22%20slang%3D%22en-US%22%3EHelp%20with%20Calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1123501%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20SharePoint%20development%20so%20please%20be%20patient.%20I%20am%20trying%20to%20evaluate%20whether%20a%20value%20in%20%5BColumn1%5D%20is%20between%2033%20and%2066%2C%20and%20if%20it%20is%2C%20put%20the%20color%20yellow%20in%20%5BColumn2%5D%20which%20is%20a%20calculated%20column.%20Can%20anyone%20tell%20me%20the%20correct%20methodology%20to%20accomplish%20this%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1123501%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1123783%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1123783%22%20slang%3D%22en-US%22%3EThis%20might%20help%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2FREADME.md%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Fblob%2Fmaster%2Fcolumn-samples%2Fnumber-conditional-format%2FREADME.md%3C%2FA%3E%3C%2FLINGO-BODY%3E
Visitor

Hi All;

I'm new to SharePoint development so please be patient. I am trying to evaluate whether a value in [Column1] is between 33 and 66, and if it is, put the color yellow in [Column2] which is a calculated column. Can anyone tell me the correct methodology to accomplish this?

Thanks

 

1 Reply