SOLVED
Home

Copy conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-323789%22%20slang%3D%22en-US%22%3ECopy%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323789%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20conditional%20formatting%20rule%20which%20basically%20says%20that%20if%20cell%20F24's%20value%20is%26nbsp%3Bless%20than%20cell%20F23s%20then%20turn%20the%20text%20red.%20But%20I'm%20struggling%20in%20copying%20and%20pasting%20this%20conditional%20formatting%20across%20an%20entire%20row%20as%20no%20matter%20which%20cell%20its%20copied%20into%20it%20takes%20the%20value%20for%20the%20source.%20eg.%26nbsp%3BIn%20the%20attached%20picture%20i've%20tried%20to%20copy%20it%20into%20the%20next%20cell%2C%20which%20is%20F24%20but%20it%20still%20takes%20E23's%20value.%20I%20tried%20removing%20the%20dollar%20signs%20but%20this%20didn't%20seem%20to%20work.%20It's%20going%20to%20take%20a%20long%20time%20to%20set%20up%20conditional%20formatting%20on%20each%20individual%20cell.%20Many%20thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-323789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-343097%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-343097%22%20slang%3D%22en-US%22%3EGreat%2C%20thanks%20for%20your%20help%20Sergei.%20Rob%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325265%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325265%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20use%20formula%20like%20this%20applied%20to%20you%20range%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20664px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70871i9A2EC8C6C59A32A4%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%3C%2FLINGO-BODY%3E
d32bus
New Contributor

Hi

 

I have a conditional formatting rule which basically says that if cell F24's value is less than cell F23s then turn the text red. But I'm struggling in copying and pasting this conditional formatting across an entire row as no matter which cell its copied into it takes the value for the source. eg. In the attached picture i've tried to copy it into the next cell, which is F24 but it still takes E23's value. I tried removing the dollar signs but this didn't seem to work. It's going to take a long time to set up conditional formatting on each individual cell. Many thanks in advance.

2 Replies
Solution

You may use formula like this applied to you range

image.png

Great, thanks for your help Sergei. Rob
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 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