Hi,
I have a checkbox sending TRUE or FALSE to a cell M4. I have another cell A4
with this formula IF(M4=TRUE,"",""). Then I have conditional formating set up
to format the cell yellow if the formula is TRUE and format the cell red if
the formula is FALSE. However, when the formula goes from true to false and
false to true it does no format changing. For example, when the formula is
first true the cell formats to yellow but when the formula goes to false it
does not. The format just stays yellow.
Any help would be great,

Thank You,