conditional formatting on If sentance
 

Hi all,
I have a cell with if condition. I want the cell bo become bold and BG
color turn to red is the statement is TRUE. I've tried to use the conditional
formatting with 'formula is' but didn't get it. (if doesn't return a value).
Any suggestions?
Thanks in advance

conditional formatting on If sentance
 

Just use a formula in the CF the same as the cell formula without the IF and
without the actions. For instance, if the cell formula is

=IF(AND(A110,B1<7),A1,C*10)

the CF formula would just be

=AND(A110,B1<7)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Lp12" wrote in message
...
Hi all,
I have a cell with if condition. I want the cell bo become bold and BG
color turn to red is the statement is TRUE. I've tried to use the
conditional
formatting with 'formula is' but didn't get it. (if doesn't return a
value).
Any suggestions?
Thanks in advance