Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |