How to Highlight Desire Data in Excel

[Chini mao]

Recently I was trying to make the high Light the desire data, so that it can be easily distinguished but however I want to make the macros or the option to be used in such a way that the desired data is highlight in the Excel. I just want that If any cell in column contains desired data in string format ( i.e."Bill G" ), how would I highlight the data range in that respective row? If any ideas then please let me know.

[JustineBB]

According to my information you just try these steps to make this thing happen in the Excel:

• Select columns A to I.
• Go to Format > Conditional Formatting
• Select "Formula Is" on the drop-down arrow, and put:=$D1="Bill G"
• Press the Format radio button and format as desired.

[BillieJ]

Select cols A to I Click Formatting > Conditional Formatting and for condition1, set it as: Formula is | =$D1="Bill G" and then Click Format button > Patterns > Red? > OK Click OK at the main dialog. This will highlight the data the you wish to highlight in Excel.

[Alfons]

Select Column A through I (or a range of cells in Columns A to I) then Format>Conditional Formatting and Formula is: =$D1="Bill G." note the $ sign to lock the column but not the row.

Pick a color from Format>Pattern and OK your way out.

[Gania]

If you re-read the response given, the 1st step was to select the entire cols A to I, not row by row. And the format formula will self-adjust
relatively to fit what is required per row. Try it again, and then test it out to convince yourself. Input "Bill G" at any cell within col D, say in
D10. You'll see that the range A10:I10 will be formatted with red fill.

[Erakna]

I think you missed the part in all three posts that specified "select columns A to I" which means select the entire columns by clicking on the column headers. If you want more columns, select them before doing the CF steps. If you want all columns, hit CTRL + A(twice in 2003) Try it, this will works.