- 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:
- Microsoft Excel