There is some one who has asked about how to conditional format based on the following criteria: Subrata.Tatamotor "I Have A Spreadsheet With Two Different Value For Example Column A Column B Column C 100 100 200 150 80 100 I Want If Column A Data Match With The Col B Data Automatically Colour Formatting Done With Diff Value If Not Match Diff Colour Appearing On The Col C" Solution: Subrata, you can try the following to format the column on conditions. Based on your query, I think you are trying to colour the format of column C(from cell C1:C3) on satisfying following conditions: 1) If cell value of Column A matches with cell value of Column B ( here I have marked the cell in Yellow colour in respective cell in column C) 2) If cell value in Column A does not match with column B ( here I have marked the cell in Red colour in respective cell in column C) 3) More over I have considered here also,that if there is no value in cell A and B column i mean blank cell then the difference will be appear as blank in column C and the respective cell will be remain with no color. So to do the conditional format as mentioned above please go through below steps: Go to Home Menu--> Select conditional format-->Select "Use a formula to determine which cells to format" Put the format as per following: =AND($A1=$B1,NOT(ISBLANK($A1)),NOT(ISBLANK($B1))) Click "Format" button and select the "Fill" color. Here I have selected "yellow" color. Press "Ok". In applies to area, put the formula as =$C$1:$C$3 Press New Rule. In formula are put the formula as:=$A1<>$B1. Select Format and repeat the above step. In here I have selected "red" color. Press "OK" . In applies to area, put the formula as =$C$1:$C$3 and click on "Apply" button. =$C$1:$C$3 For calculating difference of Column A & B put the formula in Cell C1 as follwing: =IF(AND(ISBLANK(A1),ISBLANK(B1)),"",A1-B1) Copy the above formula in C2:C3 The above formula will calculate the difference only if there is no cell blank, other wise cell values in Column C will remain blank with no color format. Try it..
Please find herewith a very easy method how to create a Dynamic Chart using Drop down list. In here I have considered simple data and chart format to enable any one understand the step by step procedure how to make a Dynamic chart.
|
|