Hi, How do I highlight an entire row by looking at one cell in a column? Thanks
D Dave Jun 11, 2009 #1 Hi, How do I highlight an entire row by looking at one cell in a column? Thanks
D David Biddulph Jun 11, 2009 #2 In Conditional Formatting, use "Formula Is" rather than "Cell Value Is", and use an absolute reference for the column and relative reference for the row, e.g. Formula Is =$L1=42
In Conditional Formatting, use "Formula Is" rather than "Cell Value Is", and use an absolute reference for the column and relative reference for the row, e.g. Formula Is =$L1=42
