Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an IF statement based on 2 criteria in an OR statement.
.....IF a1=a2 or a1=a3, show a1 contents in a4....for instance. I want to format a2 automatically depending on which of the 2 statements about a1 turn out to be TRUE. If a1=a2, show contents in a4 and make it bold text...if a1=a3, show contents in a4, and make it italic text....for instance. The problem is I can't use conditional formatting for the specific cells, because the value in a4 is going to change depending on what I type in a2 and a3. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |