Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SemiConGuy

    Conditional formatting cells that are NOT "Cell Highlighted"

    I really like the idea of creating another conditional format. I tried to use the cell function to determine if the cell was manually formatted (ie, filled) then do NOT format. Unfortunately, the cell function does not return if the cell is "filled". Perhaps there is another way to determine...
  2. SemiConGuy

    Conditional formatting cells that are NOT "Cell Highlighted"

    I created an excel spreadsheet with a conditional format of =MOD(ROW(),2)=1 which sets the fill color on alternating rows to allow for easier horizontal reading. The problem is that if the cell is "shaded" by this conditional format, I cannot manually set the fill color (example, to show...
  3. SemiConGuy

    Add-In to highlight entire row/column of selected cell in Excel?

    Whoops PMover, I think you missed the concept. We are trying to highlight a cell, column, row, etc... when another cell is selected. For me, I created a vacation calendar with dates going down the left and people's names across the top. When a person selects a cell somewhere in the middle of...
  4. SemiConGuy

    Add-In to highlight entire row/column of selected cell in Excel?

    tmukhtar: The XLS url no longer works, could you re-post it somewhere please? Eric
Back
Top