Hello all,
I'm attempting to change the font color on cell dependent on a time frame. The referenced cell if formatted as date.
I can get to work if I use this:
But can't get it to work in between times:
Please Login or Register to view this content.
What am I doing wrong?Please Login or Register to view this content.
Would appreciate any help
Thanks
Last edited by hackini; 12-14-2016 at 12:23 PM.
maybe condional formating will do the job?
Hackini, as per forum rules, please use code tags when posting code
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Sorry mate, totally forgot about that.
Cheers
Thank you for your response, I appreciate it. Found out that only colors available are vbBlack, vbWhite, vbRed, vbGreen, vbBlue, vbYellow, vbMagenta, and vbCyan.
Cheers
Thank you for your response, I appreciate it. Found out that only colors available are vbBlack, vbWhite, vbRed, vbGreen, vbBlue, vbYellow, vbMagenta, and vbCyan.
Cheers
It'd be easier to see what is going on if you could provide a sample workbook... but have you checked what the value of "Cells(i, 1).Value - Int(Cells(i, 1).Value)" is when it is not working?
After posting this I saw your follow up comments... hadn't thought of the colour not being an option... I'm glad you were able to resolve the issue.
If orange is important you could use .ColorIndex instead of .Color... index 46 is orange. (45 is also a light orange)
Last edited by Arkadi; 12-14-2016 at 12:36 PM.
Also, setting the .Color = RGB(255,102,0) is an orange.... there are a few values that will result in orange
The values for the times were ok but showed vbOrange=Empty, I was not getting an error with vbOrange, made some changes to "And" and "Or" and vbGreen and worked fine.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks