Forum Discussion
Solved
Need Automatic Conditional Formatting and the cell next to anything highlighted needs to change
Hello, I created an example based on a larger table I have created I need help with having "Column A" automatically having conditional formatting done to highlight the cell if it is not equal to ...
Perhaps something like in the attached example. CF rules used are:
=AND(ISNUMBER(A1),A1<>0) in column A:A
and
=AND(ISNUMBER(A1),A1<>0,ISBLANK(B1)) in column B
Perhaps something like in the attached example. CF rules used are:
=AND(ISNUMBER(A1),A1<>0) in column A:A
and
=AND(ISNUMBER(A1),A1<>0,ISBLANK(B1)) in column B
Riny_van_Eekelen I have it working and it is a large table that starts with a pivot and then I have IF Statements and Sumif formulas to create four different Actual Vs Budget Comparisons should I create the pivot and copy that information into the table in order to protect all of my formulas so that the pivot doesn't get expanded and overwrite what I have created?