Posts by mexmike

    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]

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


    Hi again,


    Sorry to be a pain once more!


    I've just realised that I didn't allow for any text to be Black. The list gets quite large and it's a little sore on the eyes all in Green.


    Is there a way to have Green fromatting when the values in B2 are between 20 and 100 and the values in C2 betwen 7 and 30?
    This would hopefully leave everything else in Black.


    Also, could you let me know if VBA would be easier for this?


    Thanks!!!

    I have a maintenance task sheet based on hours in one column and days in another.
    Each row contains the task followed by the hours and days due in their respective columns.

    Some task are based on both hours and days due.
    Some task are based on only hours due.
    Some task are based on only days due.

    I wish to change the font color of the TASK title in each row depending on the hours and days remaining. i.e.

    If the Hours OR Days Due where less than or equal to 20 and 7 respectively color RED
    If both Hours AND Days Due where more than 20 and 7 respectively color GREEN.
    The color of the TASK based only on Hours or Days must NOT be affected by a Blank Cell

    i.e.
    A B C
    TASK Hours Due Days Due
    Oil Change 20 7 RED
    Filter Change 21 8 GREEN
    Brake Check 100 6 RED
    Water Level 5 RED
    Air Pressure 35 GREEN

    So far I have conditional formatted the first column as below:

    Code
    =AND(B2>20, C2>7)

    for the GREEN

    Code
    =OR(B2<=20, C2<=7)

    for the RED

    but get stuck on the NOT(ISBLANK).
    As soon as I have either the Hours or Days Due cell blank the TASK goes RED.

    Your kind input is greatly appreciated.