Highlighting Data

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,973
Office Version
  1. 2019
Platform
  1. Windows
I need to write VBA code that will highlight the data in columns A to F where the date in column B 60 days past the current date in cell B2 for eg if the date in B7 is 31/07/2006 and todays date is 07/10/2006, then all the data in A7 to F7 must be highlighted in Grey

Your assistance will be most appreciated.

Howard
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,006
Office Version
  1. 365
  2. 2016
You can use conditional formating.

Highlight area you want to apply format to then Format>>Conditional Format

Formula is >> =NOW()-$B7>60

Set format to what ever you want


HTH


Dave
 

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,973
Office Version
  1. 2019
Platform
  1. Windows
Hi Dave

Thanks for the help.

I have another problem, regarding VBA in finding & Replacing data which I have posted on board, but have had no replies.

Would it be possible for you to forward your email address so that I could email you the file? If so please send me your email address to howard.cohen@ecmpe.co.za

Regards

Howard
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,006
Office Version
  1. 365
  2. 2016
Hi Howard

You should not post your e-mail address in a post rather use something like

howard.cohen_NO_SPAM@ecmpe.co.za

This way you don't get spyware e-mailing you stuff

I'll e-mail you

KR

Dave
 

Forum statistics

Threads
1,136,878
Messages
5,678,306
Members
419,754
Latest member
LordEddard

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