Hod do you change Font Color or Change Background Fill when a value is changed with a VBA Script? Or Macro?

Offroadracer_814

New Member
Joined
Aug 7, 2015
Messages
17
To All:

On a report I send to a vendor to update ship dates. Is there a way when the new date is entered either the font color (and bold) can change. Or have background fill when it happens?
3/7/2018 if a new date is applied change 3/18/18
3/12/2018
3/13/2018
3/15/2018
3/15/2018
3/16/2018
3/16/2018
3/17/2018
3/17/2018
3/17/2018
3/18/2018
3/18/2018
3/19/2018

Thanks

Kevin

<tbody>
</tbody><colgroup><col></colgroup>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
19,069
Office Version
  1. 2013
Platform
  1. Windows
Where on your sheet are these dates.
Column A or column B or what.
And are you saying any time the value in column A changes to mark this cell as bold and red?
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
19,069
Office Version
  1. 2013
Platform
  1. Windows
And are you saying any time the value in columns mentioned changes to mark this cell as bold and red?
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
19,069
Office Version
  1. 2013
Platform
  1. Windows
If the answers to my question are yes try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 3-19-18 9:25 PM EDT
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Column = 7 Or Target.Column = 8 Or Target.Column = 9 Or Target.Column = 11 Or Target.Column = 12 Then
Target.Font.Bold = True
'Target.Interior.Color = vbRed  'Not active now Remove ' if you wnat this
Target.Font.Color = vbRed
End If
End Sub
 

Forum statistics

Threads
1,171,538
Messages
5,876,094
Members
433,175
Latest member
hp109

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
Top