Forum Discussion
Aaron_Bennett
Jan 13, 2020Copper Contributor
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 ...
- Jan 14, 2020
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
Jan 14, 2020Platinum Contributor
May I ask you to read the Excel Help screens first. They are quite extensive and give many examples. If you still feel lost, could you please upload an example of your pt and analysis (with fake data). Then, I can perhaps build a small model that demonstrates what you can achieve with GETPIVOTDATA.
Aaron_Bennett
Jan 14, 2020Copper Contributor
Riny_van_Eekelen Yeah definitely I appreciate your assistance!