close
I have got conditional formatiting set up to highlight an entire row when a
field says OVERDUE
ie. Formula is =$N$4=quot;OVERDUEquot; When N4 is overdue
How do i set this conditional formating for every row in the workbook
without writing each one manualy
Change $N$4 to $N4. Then you can copy the cell and paste special formats to
the entire workbook.
quot;Rizlaburnquot; wrote:
gt; I have got conditional formatiting set up to highlight an entire row when a
gt; field says OVERDUE
gt; ie. Formula is =$N$4=quot;OVERDUEquot; When N4 is overdue
gt;
gt; How do i set this conditional formating for every row in the workbook
gt; without writing each one manualy
全站熱搜
留言列表
