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
|
|||
|
|||
Conditional Formatting
Hi
Help please I have entered the following formula into my conditional formatting boxes, formula is: C17,1 C17,2 C1=0,3 So that the cell would then be given a 1, 2 or 3 rating - however, there is no output in my cell? Am I doing this correctly or is there another way I could do this? Many thanks in advance. |
#2
|
|||
|
|||
Conditional Formatting
Hi
Conditional Formatting will only change the attributes of a cell, not the values within the cell. You would have to use a column alongside with a formula =IFC1=0,3,IF(C17,2,1)) -- Regards Roger Govier "Eán" wrote in message ... Hi Help please I have entered the following formula into my conditional formatting boxes, formula is: C17,1 C17,2 C1=0,3 So that the cell would then be given a 1, 2 or 3 rating - however, there is no output in my cell? Am I doing this correctly or is there another way I could do this? Many thanks in advance. |
#3
|
|||
|
|||
Conditional Formatting
Hi,
Conditional formatting can only assist you with formatting cells and not returning a certain output. Therefore, if you would like 1,2,3 to appear in the cell, then write the formula in the cell instead of Format Conditional Formatting. Therefore, in cell C1, the formula would be If(C17,1if(C17,2,if(C1=0,3,"What ever"))) -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Eán" wrote in message ... Hi Help please I have entered the following formula into my conditional formatting boxes, formula is: C17,1 C17,2 C1=0,3 So that the cell would then be given a 1, 2 or 3 rating - however, there is no output in my cell? Am I doing this correctly or is there another way I could do this? Many thanks in advance. |
Thread Tools | |
Display Modes | |
|
|