Hi All

I am having a issue for creating a Macro for clear data and the format in cells depend on the condition.

Particular cell range in work sheet having different formats.This is a sheet for daily rota and display lunch hour and other work.different staff members have different time scales.

I want to write a macro to clear data and format in a3:aa9 where cell value not equal "1" or "Lunch".


I appreciate if someone can help me for this please.

Thank you
Chani