Alright,
Here is the problem and what I need. I have a sheet built with a drop down menu and a formula established to change True/False to Yes/No.
Additionally I have the entire row (A2:G2) turn red when the cell receives a true statement. I need this to continue through to A150 and then regenerate when a row is added in anywhere from A2 to A150 (or more).
Problem 1: I have to create the conditional formatting for each and every row to turn red when the referenced (I) cell receives a true statement. Is there a way to generate the conditional formatting throughout the work space without writing each row? (i.e. I must reference I2 due to the true/false statement for A2:G2 and then write I3 for A3:G3 and so forth). I have tried to copy and paste the formatting and also used the click and drag option on the highlighted box; however this is only copying the already written code and not adapting it to the respective row.
Next, I have tried to create the sheet with and without a table. When adding a row, the drop down and True/False codes remain embedded but the conditional formatting for the row turning red is not consistent or remaining with the added row. Referenced above. Code for I3 to turn (A3:G3) red and then I4 for (A3:G3) and so forth. When inserting a row between A3 and A4, the conditional formatting is not copying over to the inserted row upon receipt of a true statement.
Problem 2: How can I get the conditional formatting to copy over on the inserted row and reference the appropriate cell. (i.e. there is a row added between I3 and I4. The new I4 will keep the reference to the true statement regarded in I4 and then turn A4:G4 red and the new I5 will act in the same manner according to a true statement.
As a side note, I would prefer to keep it as a sheet and not a table.
Thanks in advance for any assistance!!!
Bookmarks