Good job
Thanks ggeu, that does it. You have been a great help.
kmtech
Last Activity: Jul 26 '10, 08:03 PM
Joined: Jul 22 '10
Location:
-
mismatch type error "13&quo t;.
Thanks again for the help.
I used Col "A" as the Col w/o blank's It changes the data from text to Nos. Therefore, I am getting a mismatch type error "13".
I reformatted col A as text, it did not solve the problem.
The data in the table is updated by an Access database report. Therefore, I cannot create a dummy col....Leave a comment:
-
How to get arround type mismatch?
Yhanks for the help.
I downloaded the sample spreadsheet and macro which worked ad designed.
I had few obsticle when applied to my spreadsheet. In line cell Y10, I have text not an integer between 1 - 6; some cells are empty since not all rows are ready to assign a value between 1-6; and I was hopping to stop the highlighting at column Y. I was able to work a fix for the text...Leave a comment:
-
How to get around Excels 3 Criteria Limit in Conditional Formatting.
I have a spreadsheet named “Log” with data in range A11:X1200 that I would like to change each raw's background color based on the value in column Y for that raw. Column Y values are set between 1 and 6. Does anyone have suggestions for an auto run script to do so that does not bug down for this size sheet. The sheet does many calculations.
Thanks,
KM
No activity results to display
Leave a comment: