Forum Discussion

Aaron_Bennett's avatar
Aaron_Bennett
Copper Contributor
Jan 13, 2020

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 ...
  • Riny_van_Eekelen's avatar
    Jan 14, 2020

    Aaron_Bennett 

    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

     

Resources