Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i ignore cells with font color?
I am stuck once again. Your help is always greatly appreciated! I would like my program to go thru my range of 11 cells and ignore the cells that are already colored. I have it looping back until condition is met. How do i get it to ignore cells that have been colored blue? I just want it to look at the cells with default black font. Here is a small bit of code from the program.... grubb = Cells(J + K, "V").value tlow = Cells(J + K, "T").value thigh = Cells(J + K, "U").value While tlow grubb 'code to ignore cells with color font color other than default black Set rng = Range("D" & J + K, "N" & J + K) lowval = Application.WorksheetFunction.Min(rng) result = Application.Match(lowval, rng, 0) If Not IsError(result) Then rng(1, result).Font.Color = RGB(0, 10, 200) minValue = Application.WorksheetFunction.Min(Range(rng)) 'should return minimum value without the cells with colored font tlow = (Cells(J + K, "R").value - minValue) / (Cells(J + K, "S").value) 'calc new tlow for the "when" condition Wend ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i ignore cells with font color?
You'll have to write your own functions that determine the min and so forth.
You can write them to loop through the cells and test the font colorindex and only acknowledge cells where it is xlautomatic. -- Regards, Tom Ogilvy "chick-racer" wrote in message ... I am stuck once again. Your help is always greatly appreciated! I would like my program to go thru my range of 11 cells and ignore the cells that are already colored. I have it looping back until condition is met. How do i get it to ignore cells that have been colored blue? I just want it to look at the cells with default black font. Here is a small bit of code from the program.... grubb = Cells(J + K, "V").value tlow = Cells(J + K, "T").value thigh = Cells(J + K, "U").value While tlow grubb 'code to ignore cells with color font color other than default black Set rng = Range("D" & J + K, "N" & J + K) lowval = Application.WorksheetFunction.Min(rng) result = Application.Match(lowval, rng, 0) If Not IsError(result) Then rng(1, result).Font.Color = RGB(0, 10, 200) minValue = Application.WorksheetFunction.Min(Range(rng)) 'should return minimum value without the cells with colored font tlow = (Cells(J + K, "R").value - minValue) / (Cells(J + K, "S").value) 'calc new tlow for the "when" condition Wend ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
Using color to ignore cells in a formula????? | Excel Discussion (Misc queries) | |||
how do i ignore cells with font color? | Excel Programming | |||
how do i ignore cells with font color? | Excel Programming | |||
how do i ignore cells with font color? | Excel Programming |