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
How to copy or duplicate an existing forms quiz
Olaf Nennker in Microsoft Forms on
2 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies