Formula required to select rows with columns having a particular number

Formula required to select rows with columns having a particular number

This is quite a formatting you want to do with your Microsoft Office Excel worksheet. I was able to find a formula that applies to the task you want to accomplish in your Microsoft Office Excel worksheet. This method uses conditional formatting and it checks every cell in your entire worksheet for a specific value and it highlights the entire row where the value appears.

Here’s how to do it. Start Microsoft Office Excel. Make sure A1 is the selected active cell. In Home tab under Styles section, click Conditional Formatting and then select New Rule. See image.

In New Formatting Rule dialog box under “Select a Rule Type” section, select the last option: “Use a formula to determine which cells to format”. Under “Format values where this formula is true”, enter the following:

• =countif(1:1,”R102”)

Replace R102 with the value you want to search. After that, click Format. Select Fill tab then click on the color you want for the highlight. Click OK all through out. See image.

Again, click Conditional Formatting under Styles section and then select Manage Rules. See image.

Select the formula you just entered then under “Applies to”, replace the current value with the one below then click Apply and then OK:

• =$1:$1048575

In case the formula or the conditional formatting doesn’t work, delete the formula and then create a new one. Make sure when entering “=countif(1:1,”R102”)” and “=$1:$1048575” you do it manually.