Posted by Excel Guru on December 11, 2001 11:30 AM
I have a list of data, and beside that list I have another list where data can be entered (eg "1"'s) I would like a condition where anytime a 1 is entered in any cell between a range (eg F4 - K24) I would like the entire row to turn red. I have tried using the conditional formating tool and have found making the rows absolute by using the '$' only works for the first column. Where as any '1' that is inserted in any cell in the first column the entire row turns red, but the columns following, (eg G,H,I,J, and K), if any '1' is inserted in any cell in those columns nothing happens to the row. Any help would be appreciated.