Conditional Formatting with a Formula

[JDSOuth49]

Good Afternoon.

I am trying to wright a Conditional formatting formula for the following criteria:
1. When a check box is "TRUE" or CHECKED, it puts a "Y" in Cell E15
2. When a check box is "FALSE" or NOT-CHECKED, it puts a "N" in Cell E15

I tried this formula
=IF($E$15=TRUE,"N","Y")

--OR--
Is there another way to get the same results?

Thank you in advance...

 

[awoohaw]

just use =$E$15=TRUE as your conditional formatting formula

 

[JDSOuth49]

just use =$E$15=TRUE as your conditional formatting formula

Thank you for the information.
This does work, to return "TRUE" in Cell E15.
What formula would have this outcome? --> When a check box is "TRUE" or CHECKED, it puts a "Y" in Cell E15

 

[awoohaw]

I'm not sure what you're asking. You asked about conditional formatting. The formula to format a cell using conditional formatting will occur when the formula you use in the conditional formatting dialog box resolves to TRUE.

If you want to put a Y or N in cell E15 based upon how a check box is clicked is not using CONDITIONAL FORMATTING. It would use a formula in cell E15.
So, if the check box is associated with cell D15 then the formula in crell E15 would be:

=IF(D15=TRUE,"Y","N")

Note, there is recent developments in excel where checkbox are actual cell contents. But, I'm not all that familiar with them.

 

[JDSOuth49]

I'm not sure what you're asking. You asked about conditional formatting. The formula to format a cell using conditional formatting will occur when the formula you use in the conditional formatting dialog box resolves to TRUE.

If you want to put a Y or N in cell E15 based upon how a check box is clicked is not using CONDITIONAL FORMATTING. It would use a formula in cell E15.
So, if the check box is associated with cell D15 then the formula in crell E15 would be:

=IF(D15=TRUE,"Y","N")

Note, there is recent developments in excel where checkbox are actual cell contents. But, I'm not all that familiar with them.

Got it...

Thank you for your help