Having Trouble using conditional formatting

[commanderjarak]

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

[etaf]

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

rather than
IF(X1="COMPLETE",1,0),
use
X1="COMPLETE"

But to apply to the row , you need to add a $
$X1="COMPLETE"

[commanderjarak]

I had the =$X1="COMPLETE" previously, I only changed the formula to make sure that I hadn't done something wrong with the text in the "COMPLETE" cells (which shouldn't be, they inherit the text from the next column over)

With regards to providing a sample of the workbook, I'm not sure if the problem will even exist if I remove part of it to make a sample. I'll try and mock it up this afternoon though.