Hi!

I have another cell A4 with this formula IF(M4=TRUE,"","").

What is the purpose of this formula?

If you want to format cell A4 based on the checkbox linked cell M4.....

Conditional Formatting
Condition 1
Formula is: =$M$4=TRUE
Set color to be yellow

Condition 2
Formula is: =$M$4=FALSE
Set color to be red
OK out

Biff

"Shinra14" wrote in message
...
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,