Hello, I am hoping someone know how to help me set up conditional color coding in excel. I am needing certain cells to populate one color if the others cells are filled out wrong and another color if the cells are filled out right.

Example:

If there is a number in cell E and cell H says F1IL and cell J isn’t blank and cell P is blank all these cells turn red.

But if there is a number in cell E and cell H says (anything but F1IL) and cell J is blank and cell P has a number then all these cells turn green.

My goal is to have errors pop up when someone doesn’t fill out the information correctly, but to also not have anything highlighted if there is no information entered on that line.

Thank you for your help!

​Hello, I am hoping someone know how to help me set up conditional color coding in excel. I am needing certain cells to populate one color if the others cells are filled out wrong and another color if the cells are filled out right. Example:If there is a number in cell E and cell H says F1IL and cell J isn’t blank and cell P is blank all these cells turn red.But if there is a number in cell E and cell H says (anything but F1IL) and cell J is blank and cell P has a number then all these cells turn green.My goal is to have errors pop up when someone doesn’t fill out the information correctly, but to also not have anything highlighted if there is no information entered on that line. Thank you for your help!   Read More

​