Hi everyone,

I'm currently having some issues getting conditional formating working in my spreadsheet.

I'm using it to track how much time before our survey drawings are due to the client, and once sent, it's set up to show COMPLETE.

I'm wanting to change the colour of the row depending on the status of the job. I figured out how to do it using the formatting, but the only problem is that it isn't changing all the rows to the colour.

I've attached a screenshot, but I've even tried checking that the data I'm working with would show the same, by using IF(X1="COMPLETE",1,0), and it all appears to be correct.

Any ideas?New Picture (2).jpgNew Picture (3).jpg