Like formulas, you can secure it with the $ sign
Eg with the entire sheet selected (A1 active)
applying CF using Formula Is: =$A1<""
will colour entire rows where col A is not empty
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"rodchar" wrote:
you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?