Match Formatting (font color, highlight, alignment, etc.) based on input

J

jkreber

New Member
Joined
Apr 6, 2022
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hi all,

I am trying to use conditional formatting / VBA / whatever it may be, to match the destination output formatting with the source formatting. My lists of data vary in length and formatting. When I input a value into X1 my lists of data appear but I want the formatting to move with the lists. I've attached two screenshots. The first one is what is currently happening, the second it what I want to happen. Is there anyway to do this?

1649262742645.png

1649262989737.png
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

T
  • Question Question
Bold/change font color in a range of cells based on text formatting of other cells in row
Replies
2
Views
702
dreid1011
dreid1011
C
  • Solved
Conditional Formatting highlight cell in range based on a separate range
Replies
6
Views
612
felixstraube
F
D
  • Solved
Conditional Formatting Finding Multiple Matched Values
Replies
6
Views
619
Joe4
Joe4
M
  • Question Question
Conditional Formatting/Moving Rows Based on Matching and Opposite Data
Replies
1
Views
278
Madam_Xavier
M
G
  • Solved
History of Dates to be traced in Excel (2010) in DD/MM/YYYY format
2
Replies
11
Views
1K
MARK858
MARK858

Forum statistics

Threads
1,224,820
Messages
6,181,160
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top