"Condition" format based on Font color

Dan

Guest

Posts: n/a

20th Jun 2008

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

« Textbox Formatting Trouble | Accurate vertical scrollling? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
making a cell a certain font color based on condition	Robin	Microsoft Excel Programming	1	6th Feb 2009 11:47 AM
Using function based on "Font Color"	danai_mp	Microsoft Excel New Users	3	2nd Sep 2008 09:58 PM
Is it possible to format a font color as "transparent"?	cochranmail@gmail.com	Microsoft Word New Users	4	1st May 2006 05:56 PM
"Rule based design" or "event-condition-action" pattern?	feng	Microsoft VB .NET	1	28th Feb 2005 09:18 AM
Re: Hard drive <font color="blue"><B>data</B></font&g t; <font color="blue"><B>recovery</B></fo nt> services?	halleyscomet@gmail.com	Storage Devices	0	7th Dec 2004 03:11 PM