Re: Conditional Format Cell Color based on Two Other Cell Values Without Blank Cells

Hi,

I am still having problems with Conditional Formatting using the built in Excel formatting which seems to require very long formulas for what I wish to achieve. I was hoping to get help coding with VBA instead.

I have attached a more exact example of my problem without adding the Excel Conditional Formatting. I hope it uploads with this post.

The formula in each row of Column "A" refer to all of the posible combinations that I need. They would of course all need to be able to applied to each Cell "G" and "O" of each row and not as they are currently presented if you get my drift.

I have not been able to include the ISBLANK or NOT(ISBLANK) in all conditions due to lack of skill. I would appreciate any help arriving at a VBA solution. The columns with "TRUE" or "FALSE", only represent the formulas that I would use for the formatting. In reality they would be TASK's i.e. "Replace Oil Filter"

[ATTACH=CONFIG]65862[/ATTACH]