Do this:

A4 = IF(M4=TRUE," "," ") (one spcae for true, and 2 spaces for false)

Conditional formatting:

When cell value is equal to " " - yellow
When cell value is equal to " " - red


Hope it helps.


Shinra14 Wrote:
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,


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388895