Highlighrt a Row
Hi,
How do I highlight an entire row by looking at one cell in a column? Thanks |
Highlighrt a Row
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 -- David Biddulph "Dave" wrote in message ... Hi, How do I highlight an entire row by looking at one cell in a column? Thanks |
All times are GMT +1. The time now is 05:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com