conditional formatting if all cells in a range are filled, highlight row.

[jbashir]

Morning all,

I have a spreadsheet where i need to highlight a row based on whether all cells in that row are filled (not blank)
so if all the cells in the row are completed and filled in I would like the row to turn green, but if there is one cell missing data the row will need to remain uncolored.

This is for use in a report completed weekly by various people - I need to see at a glance if all data has been submitted and that there is no missing data,

any help will be much appreciated,

Thanks,

 

[AliGW]

Is the data numeric or text? Are the blank cells really blank, or do they contain formulae?

 

[jbashir]

the data is numeric and yes the cells are really blank

 

[AliGW]

Then you should be able to create a formatting rule using something like:

=COUNTBLANK(A1:Z1)=0

 

[jbashir]

worked perfectly, thank you :smile:

 

[AliGW]

You're welcome!