Most valuable professional
  • Hot Topics

Excel Conditional formatting formula - multi criteria please

conditional formatting? I posted something similar to this some time ago but never got an answer and it 'fell off' the board. Here's hoping for a solution this time please. 1. Formula please to highlight the cell in column H that is equal to or nearest to J1 IF the cell in the same row in column J equals 7 2. Formula to highlight the cell in column B if the cell on the same row in column H is highlighted as a result of the above. * 1 2 3 4 5 6 7 8 9 10 11 12 13 Excel tables to the web >> Excel Jeanie HTML 4

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of April 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel