Conditional formatting

[rscmkj]

In column (L) I would like to highlight the cells(L6) based on if the the cells in column (K6) >30. I will need to repeat this for all of the cells in my workbook. Any help would be greatly appreciated. I am drawing a blank.

Thank you,
Amanda

[TABLE="width: 119"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Mentor82]

Hi,
You want to highlight cells on column L only from l6 on, don't you?
If so, select range L6 to the last cell you want to highlight and insert the conditional formatting with the following formula =K6>30 and set the conditional formatting colour that you prefer.
Regards,
Sebastian