Can we Get/Apply the Information of the Conditional Formatting used in any cell using VBA?
Dear Forum,
In one of my recent posts, I received help in getting the information of the Formula, Value and various aspects of Formatting..
However, is it possible to get the information for the Conditional Formatting which is applied in the cell whose information I seek..
Like for Example :
I need to find the information for a particular cell which has a conditional formatting such as if the value contains the number between 0-25 then the Font Colour is RED , if the value is 26-50 then Orange and if the Value is 51-75 then Green and if the last range 76-100 is Blue.
Now I know how to apply the same using conditional format dialog box manually however I need to extract this information from an already existing conditionally applied cell..as Information as well as I should be able to replicate this same information to a different Sheet using VBA..
Warm REgards
e4excel
Bookmarks