| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Condition" format based on Font color
I have a spread sheet that I am using 3 specific columns A, E, G.
if say cell "A5" is .font.colorindex=1 and "G5" is <=110 I need "E5" ..interior.Colorindex=36 A = ID number which are colored by ID type which is why I am using the font color to differentiate. E = Is an assignment number G = A compleation number Depending on type adjusts the <= in "G" Since this needs done for each row I wasn't sure if or how to apply a conditional format or the proper codeing. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and bring the "font color" of the cell across? | Excel Worksheet Functions | |||
| Using function based on "Font Color" | New Users to Excel | |||
| change font color for cells starting with "T " | Excel Programming | |||
| Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) | |||
| How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming | |||
Hybrid Mode
