Format a range depending on inputted values

    Hi!


    I have an Excel sheet where I want to change the color of a range of cells on a row



    The input from the user will be added from row 4 and downwards. I want to change the empty cells in the row from A to J depending if they have inputted some data or not.


    For example, data have inputted into row 4, column A-C. D-J is empty.


    Then A-C should be colored green and D-J should be colored red.



    Some rules that this excel sheet have:

    • If Column A is filled with the value “N”, columns C and H should be green (as they aren’t needed to be filled)
    • If column A is filled with the value “C”, columns C and H should be red if they are not filled.


    How can this be achieved with Conditional Formatting in a smart way?


    Sample1


    Sample2

    Select columns C & H, do Conditional Formatting, formula, with a formula of =$A1="N" and set as green. Do another one for the "C" and red case.

    Cheers, Glenn.


    Beauty is in the eye of the beer-holder.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login