Home

How do I Multiply Conditional Formatting to Following Cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-826167%22%20slang%3D%22en-US%22%3EHow%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826167%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20it's%20possible%20that%20can%20I%20multiply%20a%20conditional%20format%20or%20a%20ruleset%20of%20conditions%20in%20a%20cell%20through%20following%20cells%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128887i8867E9CBD4B40E9A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20choose%203%20different%20rules%20for%20formatting%20the%20cells%20in%20the%203rd%20row.%20and%20this%20list%20is%20endless%20%3A)I%20mean%2C%20I%20cant%20write%20down%20all%203%20rules%20for%20each%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20an%20option%20like%20the%20format%20painter.%20Copy%20the%20format%20of%20the%20cell%20and%20then%20paste%20it%20where%20ever%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20the%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826485%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826485%22%20slang%3D%22en-US%22%3ECopy%20the%20cell%20with%20the%20right%20settings%20and%20paste%20special%2C%20formatting%20on%20top%20of%20the%20other%20cells%20should%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826488%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826488%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%20but%20I%20already%20tried%20it%20before%20I%20came%20to%20this%20point.%20It%20doesn't%20change%20the%20source%20cell%20by%20special%20paste%2Fformats%20option.%20I%20mean%2C%20if%20you%20use%20functions%20for%20conditional%20formatting%2C%20it%20only%20changes%20the%20target%20cell%20that%20you%20paste%20the%20format%20which%20copied%20from%20the%20other%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826525%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826525%22%20slang%3D%22en-US%22%3EI%20don't%20think%20I%20understand.%20But%20you%20can%20open%20the%20rules%20manager%20(Conditional%20format%2C%20Manage%20Rules...)%20and%20change%20the%20range%20to%20which%20a%20rule%20applies%20in%20that%20list.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826535%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20already%20added%20example%20file.%20You%20can%20check%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826633%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826633%22%20slang%3D%22en-US%22%3EI%20have%2C%20but%20I%20did%20not%20understand%20the%20question.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828134%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399457%22%20target%3D%22_blank%22%3E%40Serhat_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20I%20understood%20the%20logic%20exactly.%20For%20such%20sample%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20815px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128997iFE2F3EEEE5523CBE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eyou%20may%20select%20entire%20column%20C%20and%20apply%203%20rules%20to%20it%20with%20formulas%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3Eyellow%3A%0A%3D(%24C1%26lt%3B%24A1)*(%24C1%26gt%3B0)%0A%0Ared%20font%0A%3D%24C1%26gt%3B%24B1%0A%0Ablue%0A%3D(%24C1%26gt%3B%3D%24A1)*(%24C1%26lt%3B%3D%24B1)*(%24C1%26gt%3B0)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EThat's%20in%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-828505%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20Multiply%20Conditional%20Formatting%20to%20Following%20Cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828505%22%20slang%3D%22en-US%22%3EI'll%20try.%20thank%20you.%3C%2FLINGO-BODY%3E
Serhat_K
New Contributor

Hi,

I don't know if it's possible that can I multiply a conditional format or a ruleset of conditions in a cell through following cells? 

 

clipboard_image_0.png

 

I choose 3 different rules for formatting the cells in the 3rd row. and this list is endless I mean, I cant write down all 3 rules for each cell. 

 

I'm looking for an option like the format painter. Copy the format of the cell and then paste it where ever you want.

 

I added the example.

 

Thanks in advance..

7 Replies
Copy the cell with the right settings and paste special, formatting on top of the other cells should work.

@Jan Karel Pieterse 

 

Thanks for your time but I already tried it before I came to this point. It doesn't change the source cell by special paste/formats option. I mean, if you use functions for conditional formatting, it only changes the target cell that you paste the format which copied from the other cell.

I don't think I understand. But you can open the rules manager (Conditional format, Manage Rules...) and change the range to which a rule applies in that list.

@Jan Karel Pieterse 

 

I already added example file. You can check it out.

I have, but I did not understand the question.

@Serhat_K 

Not sure I understood the logic exactly. For such sample

image.png

you may select entire column C and apply 3 rules to it with formulas like

yellow:
=($C1<$A1)*($C1>0)

red font
=$C1>$B1

blue
=($C1>=$A1)*($C1<=$B1)*($C1>0)

That's in attached

I'll try. thank you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies