I have posted before about conditional formatting and I have a piece of code that works for integer numbers but when I try to implement it for a cell that is formatted to percentages it doesn't work. The cells are also formatted with a formula. Sample workbook and code attached, I would greatly appreciated anyone who could help me.
Formula:
Please Login or Register to view this content.
Dimension ILow and IHigh as single (which allow for decimals) and then set their values to -.03 and 0.5 in your routine
Elegant Simplicity............. Not Always
since excel uses Doubles internally I suggest you do the same-you will often find the change from single to double makes small alterations to your values
Josie
if at first you don't succeed try doing it the way your wife told you to
I have tried both single and double but the code is ignoring the less than condition where it turns green. There is only one field that is less than -3 (H32).
I see my problem now. -0.3 is 30 percent so I changed my 0.3 to 0.03 which makes the parameter 3 percent. Such a simple thing to get confused at! Thanks for the help guys
worked for me on your sample-what is the exact code you tried?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks