highlight rows

  1. C

    Highlight entire rows in used range where any cell contains searched text

    I have read no less than 50+ help articles, watched at least that many tutorials and scrubbed the posts here for any insights, but can't seem to find precisely what I am looking for. I have a spreadsheet tracking issues/tasks (range A7:AZ1005). In cell $Q$1 the user can enter a word to search...
    • CorrieAnn
    • Thread
    • conditional formatting highlight rows message box search vba
    • Replies: 5
    • Forum: Excel Questions
  2. T

    Highlight Rows

    I don't know if this is possible, but I would like to be able to highlight a row by using ctrl+F and by typing in what is in column A, be able to highlight the row in blue. When I type in what is in column A while it is highlighted in blue, I want it to turn green. When I type in what is...
  3. Q

    Highlight Rows if today's date is between 2 column dates

    <tbody> Row Index Column D (Start Date) Column E (End Date) A 20-JUL-2014 27-JUL-2014 B 01-OCT-2014 01-NOV-2014 C 07-OCT-2014 09-OCT-2014 D 09-OCT-2014 01-NOV-2014 E 14-AUG-2014 07-OCT-2014 </tbody> Seeking expert assistance in building a conditional format for...
    • QueenS
    • Thread
    • conditional fomratting date and range highlight rows
    • Replies: 4
    • Forum: Excel Questions
  4. S

    Highlight row based on checkbox with and without VBA code

    Hi, I've created excel file with old movies (from TSPDT site) and I've added checkbox column. I would like the row from cell A to cell H to highlight green if the checkbox is checked, and to highlight red if it's unchecked. I've tried rightclick checkbox, then format control, and then link...
  5. N

    Highlight Rows if more than 2 columns are entered

    Hi, I have to highlight those rows in my excel sheet which have more than 2 columns among 3(C,D and F) entered. Plz help !!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top