Faysal Easy Excel

Without VBA you can highlight the whole row with a specific color. Through VBA code it is very easier. But many people do not like VBA or cannot use VBA code due to security purpose. Today I'm going to show you how can you highlight whole row based on your Active Cell. Step by Step: (1) Select entire workbook by pressing Ctrl+A. (2) Click on Home | Conditional Formatting | New Rules | Use a formula to determine which cells to format. (3) Use the formula =CELL("row")=ROW() (4) Click on Format button and Select a Fill color (5) Click Ok. Now show the Cursor blinking by pressing F2 or Double Clicking a into a Cell. Then Click any Cell, that you want to highlight the entire row of that Cell. Image 1: Setting of Conditional Formatting |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

Assume that, You have a worksheet with conditional formatting from A1:A23 cell. In many case you have to remove conditional formatting from that worksheet like, wrong conditional formatting applied, clear the worksheet for printing etc. To remove conditional formatting you should follow the below steps: How to remove conditional formatting from worksheet? Step 1: Select A1:A23 cell that contains the conditional formatting. Step 2: Click on Home | Conditional Formatting | Manage Rules.. Step 3: Conditional Formatting Rules Manager dialog box will appear like below: Image 1: Conditional Formatting Rules Manager dialog box Step 4: As you see that, Duplicate Values conditional formatting rules has already been selected. Just Click the Delete Rule button to delete this conditional formatting rules. Step 5: Now click on Ok. |||| Please SUBSCRIBE our YouTube Channel |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

Conditional Formatting is an Excel Tool that allow users to apply custom cell formatting to a selected cell or it can be a selected range based on criteria. The criteria can be set by using hard code value or by using a formula. For example, You have a range A2:A10 which contains numbers between 1 to 9 in each cells. Now it is difficult to look for a number say 8 from this range within seconds. But if you apply a conditional formatting with a condition that, if the number is 8 then it becomes YELLOW as fill color. After applying this you can easily find the number 8 from the range in milliseconds. If you think that, A2:A10 is very short range where only 9 cells need to look and you will find it easily. But think, you have a table, whose range is A2:G10, now how can you find the 8? Conditional Formatting is a way by which an additional formula or a set of additional formula can inject into each cells. What are the types of Conditional Formatting? For data analysis an MIS Exe...