Solved Conditional Format problem

[forestview]

Hi stuck with this one

I have a spreadsheet used by several people to enter data row by row and i want to have a conditional format to one of the columns such that if the data has been entered in to the row and the cell of this column has been missed the format will be applied, i don't want the whole column to be formatted based on it being empty as this will fill the whole column below the entries with the format.

Thanks

This is my first post

[NeedForExcel]

So basically you want all the rows (Not the whole row) of that particular column to be Highlighted, only if they the data in whole row is filled but cell from that particular column is empty..

Is it right?

[Joe Bushfield]

Can you post an Example?

[forestview]

Hi
As they go along the row populating the data if the cell in the column i want to format is missed then format applied

[NeedForExcel]

See if this works -

[forestview]

Hi needforexcel

Brilliant

Applies your attached formula and adjusted accordingly and it working a treat, thanks for your support.

forestview

[NeedForExcel]

Glad it helped!