Conditional Formatting

[trevolly]

Hi all

I'm really sorry to ask what is probably such a simple question. I have a checkbox that is linked to DA10 and have used a conditional format to colour some cells when it is ticked / unticked (True / False value). This is using =$DA$10 and then a specific colour to change the colour of a cell.

Id like to be able to link another cell to the same cell , DA10, so that that cell switches between two colours depending on the True / False value in DA10.

Thank you if anyone can help

 

[trevolly]

Dont worry all - worked it out - cant see how to delete this post