Here is my issue. I have column G that has dates and I want to change the color to green if any value at all is entered in colomn W of the same row.
I have tried a few formulas but cant seem to get it to work right. I have column G with conditional rules to change to colors depending on date range.
so to understand example: if column g row 17 has 11/30/16 and column w row 17 has 12/01/16 I want column g row 17 to turn green. if column g row 17 has a date and column w row 17 has no date I don't want there to be any effect. I have thousands of rows. I just need column g to change color if column w on the same row has a value in it.
I have tried a few formulas but cant seem to get it to work right. I have column G with conditional rules to change to colors depending on date range.
so to understand example: if column g row 17 has 11/30/16 and column w row 17 has 12/01/16 I want column g row 17 to turn green. if column g row 17 has a date and column w row 17 has no date I don't want there to be any effect. I have thousands of rows. I just need column g to change color if column w on the same row has a value in it.