Okay, I've spent way too long on this problem so I'm looking for a little help again, because it's become painfully obvious that I'm an idiot.
I have a workbook that has three sheets. The first sheet contains an ID number in Column A that is duplicated in the other two sheets, also in their respective Column A cells. The first sheet contains basic information for each ID number in each row, the second sheet contains inspection dates and comments, and the third sheet contains testing results. What I need is the ability to turn one row green across all three sheets when I input the completed date in Column F on Sheet 2, or to turn it red if I enter a date in Column H on Sheet 3. My workbook has 700 rows, and I need the ability to turn any of them red or green across all three sheets, depending on the pass or fail dates entered on their respective rows.
I have tried using Conditional Formatting, and have tried pirating macros that I've found by searching online and then adopting them to my sheet, with no luck at all. I don't care which method gets used, as long as it works as intended. But I can tell you now that if someone tells me how to do it using Conditional Formatting, apparently you'll have to spell it out as if I was a small child, because I have failed miserably in my attempts to date.
Any assistance at all will be greatly appreciated, and will halt my inexorable slide into Excel-induced madness.
I have a workbook that has three sheets. The first sheet contains an ID number in Column A that is duplicated in the other two sheets, also in their respective Column A cells. The first sheet contains basic information for each ID number in each row, the second sheet contains inspection dates and comments, and the third sheet contains testing results. What I need is the ability to turn one row green across all three sheets when I input the completed date in Column F on Sheet 2, or to turn it red if I enter a date in Column H on Sheet 3. My workbook has 700 rows, and I need the ability to turn any of them red or green across all three sheets, depending on the pass or fail dates entered on their respective rows.
I have tried using Conditional Formatting, and have tried pirating macros that I've found by searching online and then adopting them to my sheet, with no luck at all. I don't care which method gets used, as long as it works as intended. But I can tell you now that if someone tells me how to do it using Conditional Formatting, apparently you'll have to spell it out as if I was a small child, because I have failed miserably in my attempts to date.
Any assistance at all will be greatly appreciated, and will halt my inexorable slide into Excel-induced madness.