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.

*ABCDEFGHIJ
1*********17
2**********
3**********
41Red*****7*7
52Black*****8*7
63Blue*****17*3
74Green*****8*7
85White*****49*6
96Brown*****5*2
107Grey*****31*5
118Scarlet*****11*6
129Yellow*****13*5
1310Orange*****22*1


Thank you - your help is appreciated


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