I have this function in my worksheet to change cell colors and fonts depending on the input. Its works great however, the workbook rounds up a fraction. For example if the user inputs 1.5 then the workbook will change it to 2. I would like NOT to round up.
I do not want to go to Format Cells because I already have a custom formula in there. Can I do this within this function code? Thanks in advance
Please Login or Register to view this content.
Just change the cell formatting to General; it won't affect the formula.
That's a lot of processing to do each time the selection changes.
Entia non sunt multiplicanda sine necessitate
I want to avoid that because I alread have
[Red][>=8]#;[Blue][>0]#;General
Last edited by shg; 04-12-2010 at 02:00 PM. Reason: deleted spurious quote
Try [Red][>=8]General;[Blue][>0]General;General
That worked. Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks