conditional formatting on If sentance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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(A1>10,B1<7),A1,C*10)

the CF formula would just be

=AND(A1>10,B1<7)

--
HTH

Bob Phillips

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