values from cells

Hi, need help with highlighting cells that don't fall with my range of specifications. My spec is 40-60. I would like to highlight the values in the data cells which fall from 0-39 and from 61 up. I'm sure it is an easy fix. Can anyone help me with this one?

Dear people who are willing to help, I am currently doing an internship for a company (I'm still a student) and they are asking something from me that seems near impossible in Excel. There are colums with names of the employees There are rows with work stations There is a list if where...

I have a range which consists of 1 row x 12 columns but columns are not continuous & are 'spitted' like B2:D2; G2:I2 & L2:Q2. Each cell in the above range=value or "" (null). Output required: 1. S2=Value of Rightmost cell (in the range) having value>0 2. T2=Value of Rightmost - 1 cell i.e. 1...

Hi, How are you guys??? I was reading and searching the forum to find if anyone has my same question but I found that the things I found were quite different. Going to the point I need to make this thing: I got 1 column that has different and sometimes repeated values: <tbody> Cells...

First time poster here so I hope I do this correctly! Using Excel 2010 I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide...

Hi I am relatively new to excel vba, but I am looking for some advice about creating a macro that I can run over a number of worksheets in a workbook. The advice I am looking for is to take 3 columns where I can find certain values in those columns. Where a row has a value in each of those...

Hello i didnt get an answer last time please help me solve this i need to count all the cells that have a value across the calendar column G to AC FOR ALL column B THAT HAVE GCE and only for the start and finish date of of my input so when i input a start and finish and i want to find how...

Hi. I need som VBA help. I have a ListBox with three columns. These columns should be filled with values from column A to C. It's fine this far, and I can figure out how to get the values but with massive code to get values from each cell if I know how many rows I have... Now, as the rows...