• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 94
  • Last Modified:

Replicate Rule of Conditional Formatting

Is there any macro available to replicate a Rule of Conditional Formatting?

Let's say currently I got 3 rules in a selection/workbook, how can I replicate the first rule (green background with yellow font, or whatever) and become the 4th rule?

SnapShot.png
Or in another word, use macro to read the Conditional Formatting Rules, and create a new Rule? Any ideas?

Thank you.
0
trowa
Asked:
trowa
  • 3
1 Solution
 
John TsioumprisSoftware & Systems EngineerCommented:
You can do this via VBA...here is a guide from Microsoft.
Side Note : I have found personally that the FormatCondition is a bit sensitive so add in your code
On Error Resume Next

Open in new window

I know its a bad practice but lets say that it will bypass many FormatCondition  hiccups
0
 
trowaAuthor Commented:
Hi John,

Not too sure if that worked in Excel but in the article, it mentioned:

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Thank you.
0
 
trowaAuthor Commented:
I think I solved it by simply select the cell then copy and paste to another cell, and it's working fine to replicate the rules. No VBA code was involved!

SnapShot.png
0
 
trowaAuthor Commented:
No longer need a macro solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now