How to add conditional formatting in one cell in a spreadsheet based on a value of another cell in this same row?

Here you have the magic formula that will reference a value in column A for the same row that your current cell is:

=$A1

And here is a quick ToDo app based on that in Google Spreadsheets:

Cheers