Copy a cell's condiitional formatting based on text in the cell

Iwanttoexcel

New Member
Joined
May 6, 2019
Messages
1
Hello! 1st time poster here!

I have a manifest of a semi truck that is being delivered. (1500 items at random)

Column N is the price
Column O is the unique Identifier Formatted blue if over $100, red if under $40, nothing if in between

We will scan the unique identifiers as they come off the truck (Completely random order) into column P

I have it formatted to show up as duplicate (Dark red Text) but I'd like it to copy the conditional formatting as well (blue, red, or none). Is that possible? Thank you!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,096,029
Messages
5,447,955
Members
405,474
Latest member
faworange

This Week's Hot Topics

Top