I have the code below that uses conditional formatting to add a colour to a cell depending on the number that is in the cell. When the number is -3 or below it should turn green but doesn't. When the number is between -3 and 50 it should be amber and over 50 is red. The code only seems to be printing amber and red and ignores the condition for turning the cell green.
Please Login or Register to view this content.
Last edited by arlu1201; 07-22-2013 at 06:26 AM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks