Formatting BOLD Using a Formula

[meppwc]

I am trying to figure out if a formula can be used to control the format of a cell
For Example

If C3 or F3 is populated, then, make the contents of B3 bold

Is there a way of doing this?

 

[RoryA]

You can use conditional formatting for that, but not a formula in a cell. Does that help?

 

[meppwc]

I do see what you are recommending RoryA...............but I am confused on how to implement it
I went to conditional formatting, selected "use a formula to determine which cells to format"
I put in cell A3 the following formula
=IF(OR($C$3<>"",$F$3<>""))
And then selected formatting to be BOLD and ITALIC
But nothing happened............cell C3 has data and F3 does not
So A3 should be BOLD and ITALIC
Is the formula incorrect?

 

[Joe4]

Use this as your formula:

=OR($C$3<>"",$F$3<>"")

 

[meppwc]

Nevermind RoryA...............I figured it out...........=IF(OR(C2<>"",F2<>""),TRUE)

 

[Joe4]

You don't need the IF part at all - OR and AND are boolean functions that return TRUE or FALSE on their own without using IF.
See my previous response above.

 

[meppwc]

Thanks Joe4.............that is good to know

 

[Joe4]

You are welcome.

You can also create your own boolean expressions.
For example, let's say that you wanted to highlight cell A1 if C1 is equal to "dog".
Instead of writing:

=IF(C1="dog",TRUE,FALSE)

you can just use:

=C1="dog"

Basically, based on the value of C1, the equality expression you created is either TRUE or FALSE, so that is what is returned.

 

[meppwc]

Thanks again..............never know when these shortcuts will come in handy...........believe it or not I do keep a log file of all these types of suggestions

 

[Joe4]

believe it or not I do keep a log file of all these types of suggestions

I like it!