Conditional Formatting

[Calibre16]

Hello,

I would like to conditionally format a row of cells to highlight green only when the last cell(completed date) is populated.
How do i do this?

Thanks

Cal16

 

[JoeMo]

Select the cells in the row you want to CF. Let's assume for illustration the last cell is K2.
Home>Conditional Formatting>New Rule>Use a formula

Formula is: =$K2<>""

select the format you want to apply.
click OK

 

[Calibre16]

Thanks.
Now how can I replicate that down the worksheet as the table has 100 lines.

Cal16

 

[JoeMo]

Thanks.
Now how can I replicate that down the worksheet as the table has 100 lines.

Cal16

Copy and paste special formats, or use the format paint brush.