|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 19th, 2010, 10:59 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Conditioinal Formating Question
Hi I'm trying to do a conditional format where as if two values from two
different cells equal a number a letter is displayed as apposed to a colour? Thanks in advance 
|
|
#2
April 19th, 2010, 11:05 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditioinal Formating Question
Hi,
I'm not sure I fully understand but you can try this =IF(A1+B1=3,99999,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Harminder" wrote: Hi I'm trying to do a conditional format where as if two values from two different cells equal a number a letter is displayed as apposed to a colour? Thanks in advance
|
|
#3
April 19th, 2010, 12:15 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditioinal Formating Question
OR , do you mean
If values of A1 and B1 are 5 then a letter is displayed. =IF(AND(A1=5,B1=5),"Letter to be displayed","") -- Jacob (MVP - Excel) "Harminder" wrote: Hi I'm trying to do a conditional format where as if two values from two different cells equal a number a letter is displayed as apposed to a colour? Thanks in advance
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
