Shri G Posted April 22, 2022 Share Posted April 22, 2022 Hi All, I have a data similer to below data in table (simple table and not cross table). Date Lines Count 1 Count 2 Count 3 10/04/22 T1_data_c 10345 10345 20690 11/04/22 T2_data_c 0 0 200 12/04/22 T3_data_c 281 81 945 13/04/22 T4_data_c 100 0 230 count 1 and count 2 values are matching but in case if there is a disconnect/diffrence in count i have to highlight the row (only count 1 and count 2 column row). If the difference between count 1 and count 2is between 1% to 5% then i have to highlight those rows in green. If the difference between count 1 and count 2 to is between 6% to 10% then i have to highlight those rows in red. and if difference if greater then 10% then i have to highlight in blue. Can somebody please help me Thanks, Shri Link to comment Share on other sites More sharing options...
Fabian Duerr Posted April 24, 2022 Share Posted April 24, 2022 You can only color a cell by the value of the cell. You can't color the cell by any calculation. So the only way here is to create a caluculated column with the difference of Count 1 and Count 2 and to use conditional formating on this column: properties -> color -> add color scheme group. Sorry for the bad news ;) Link to comment Share on other sites More sharing options...
Jose Leviaguirre Posted April 25, 2022 Share Posted April 25, 2022 Hello Shri You can use color grouping and use a boolean custom expression color rule to color multiple cells of the same type. Since you have mixed data types, you will need multiple color scheme groupings and use the same coloring rule. You can create a calculated column to determine the color you want to code your rule to make it easier to understand. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now