Need help for Conditional Formatting with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1529667%22%20slang%3D%22en-US%22%3ENeed%20help%20for%20Conditional%20Formatting%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529667%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20formula%20to%20conditionally%20format%20a%20cell%20(E4)%26nbsp%3B%20based%20on%20a%20value%20in%20another%20cell%20(S4).%20Now%20I%20want%20to%20copy%20that%20formatting%20to%20other%20rows.%20I've%20tried%20copying%20and%20pasting%20special%20as%20well%20as%20format%20painter%20but%2C%20for%20example%2C%20they%20copy%20to%2C%20say%2C%20E55%20but%20instead%20of%20formatting%20that%20cell%20based%20on%20S55%2C%20it%20uses%20S4.%26nbsp%3B%20Please%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529768%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20help%20for%20Conditional%20Formatting%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529768%22%20slang%3D%22en-US%22%3ESorry%20can't%20quite%20follow%20...%20can%20you%20upload%20a%20sample%20file%3F%20...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529786%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20help%20for%20Conditional%20Formatting%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529786%22%20slang%3D%22en-US%22%3EHave%20a%20look%20here%20...%20maybe%20this%20will%20help%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fvideo-kopieren-und-entfernen-2bcf4513-c84a-44ae-9033-e5ae95d0f43f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fvideo-kopieren-und-entfernen-2bcf4513-c84a-44ae-9033-e5ae95d0f43f%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529967%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20for%20Conditional%20Formatting%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732102%22%20target%3D%22_blank%22%3E%40RoadRanger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20739px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206120i1F02106ACC656251%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ejust%20be%20careful%20with%20absolute%20and%20relative%20references.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have created a formula to conditionally format a cell (E4)  based on a value in another cell (S4). Now I want to copy that formatting to other rows. I've tried copying and pasting special as well as format painter but, for example, they copy to, say, E55 but instead of formatting that cell based on S55, it uses S4.  Please help

3 Replies
Sorry can't quite follow ... can you upload a sample file? ...

@RoadRanger 

Perhaps

image.png

just be careful with absolute and relative references.