Very new to excel and have been finding code all over the internet to make my spreadsheet work but having a tough time with this issue.
I am using the code =MIN(IF(A1:C1000=CL1,ROW(A1:C1000))) ,control, shift ,enter... to match a range and display the cell I am looking for.
Then I need to take that result and do a conditional format to highlight the text red if the result is a blank cell.
For example if the result of the above code is 20 then i need to insert it into a conditional format code and tell me if c20 is blank by highlighting the text red.
I have been researching isblank and indirect but cant seem to get it working properly.
Bookmarks