<div>
On the Home tab - conditional formatting, then New rule... and choose 'Use a formula to determine which cells to format. &nbsp;Then you can enter your function, and select the formatting you want
</div>


TrueFalse-Cond-formating.xlsx

<div>
Hi,<br />
<br />
Thanks for that but I am a bit confused. I can see how to set the formatting for true,<br />
but how then do I format it for False?<br />
<br />
Thanks,<br />
<br />
Ward.
</div>


<div>
did you check the file I posted ?<br />
gowflow
</div>


<div>
You use two conditional formatting rules.<br />
One rule for TRUE and one rule for False.<br />
&nbsp; &nbsp;OR - you can format the cell for FALSE and only test for TRUE.
</div>


<div>
I presume you have loaded the file I posted<br />
1) once loaded goto menu Home and click on the arrow under Conditional formating<br />
2)Select Manage rules<br />
3) you will see 2 rules the first one Cell Value = FALSE then Red color and the second one Cell value = TRUE then Green color.<br />
4) if you want to modify this click on the rule you want click edit then you will see the data and can change the conditio nand the color.<br />
<br />
gowlfow
</div>


<div>
Again when you say<br />
but how then do I format it for False?<br />
If your confused on how empty cells are turned Red is that by delfault empty = 0 = false so if your not happy with all cells turning red by default then change the output of your formula to be say Yes and No and then affect Yes to Green and No to Red this way only input of formula will be colored and empty cells will remain blank !!!<br />
gowflow
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to work out how to do this in Excel 2007.<br />
<br />
I would like to do a conditional formatting based on a return <br />
value of a function.<br />
<br />
If the function returns &quot;True&quot;. I want the cell formatted as green.<br />
If the function returns &quot;False&quot;, I want the cell formatted as red.<br />
<br />
So I have created the VBA function, what I am stuck on is how to do the<br />
conditional formatting in Excel 2007.<br />
<br />
I am looking for the basic steps.<br />
<br />
Thanks,<br />
<br />
Ward.<br />
<br />
&nbsp;
</div>
</div>


Hi,

I am trying to work out how to do this in Excel 2007.

I would like to do a conditional formatting based on a return 
value of a function.

If the function returns "True". I want the cell formatted as green.
If the function returns "False", I want the cell formatted as red.

So I have created the VBA function, what I am stuck on is how to do the
conditional formatting in Excel 2007.

I am looking for the basic steps.

Thanks,

Ward.

 

Excel 2007 Conditional formatting based on a function value.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.