Excel VB code
I would like to know how can I create a VB code in excel for this task:
I have two columns with day and tem values
Day Temp
10.4 4.3
11.5 6.7
etc
I want to select those day values that have a decimal 5 (10.5, 5.5, 3.5, etc) with its respective temp value
Can someone help me???
Software/Hardware used:
Excel 2007
Software/Hardware used:
Excel 2007
ASKED:
March 12, 2010 6:22 PM
UPDATED:
March 18, 2010 11:16 PM
Answer Wiki:
On the basis of KeepItSimpleStupid, have you considered using conditional formatting?
If you are keeping track of temperatures on an hourly basis per day, make cells A2, A3, A4..........A366(7) your dates and the hours columns are B1, C1, D1............Z1. In cell AB1 place the figure 0.5.
Select the cells in the range B2:Z368 and format for Number with 1 decimal place. Whilst this range is selected, go to Format, Conditional Formatting, Formula Is =IF(B2-INT(B2)=$AB$1,TRUE,0) You can then select whichever format suits your needs. As you input your temperatures this formatting should apply to all temperatures ending in .5 .
Trusting that this is of some assistance, regards l.p52@hotmail.com
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
