Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF fuction and format ...
Greetings
In IF fuction, how can I get answer with different format ... ? Like if the answer true , I get result with blue font and if the answer false I get the result in red . How can I do that ? Regards Mustafa J. |
#2
|
|||
|
|||
Hi
a formula can not change cell formatting. One way, however, to do this is using Conditional Formatting ... which is on the format menu. Check it out and if you need more assistance please post back with the IF function you're using. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "MJK700i" wrote in message ... Greetings In IF fuction, how can I get answer with different format ... ? Like if the answer true , I get result with blue font and if the answer false I get the result in red . How can I do that ? Regards Mustafa J. |
#3
|
|||
|
|||
Hi JulieD, Thank you for replay
I have 3 columns, 1st containing empty and non-empty values, 2nd & 3rd containing values. The If function checks the 1st set of data if it is non-empty it gets the results from 2nd set and if it is empty then get the results from the 3rd set. The IF function results give a one column of data. I want to know for each number comes from which set? 2nd set as a blue and 3rd set as a red. Conditional Formatting give a format depends on the number in a cell not from other cell. I am thinking to get a formula like : =IF( A10, [BLUE]B1,[RED]C1) where [BLUE] and [RED] are results with formatting. But that IF statement is not correct. Can you help ! Regards,,, MJK700i "JulieD" wrote: Hi a formula can not change cell formatting. One way, however, to do this is using Conditional Formatting ... which is on the format menu. Check it out and if you need more assistance please post back with the IF function you're using. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "MJK700i" wrote in message ... Greetings In IF fuction, how can I get answer with different format ... ? Like if the answer true , I get result with blue font and if the answer false I get the result in red . How can I do that ? Regards Mustafa J. |
#4
|
|||
|
|||
Try this ..
Assuming the 3 cols are cols A, B and C, and the IF formula is in col D, all from row1 down Select col D Click Format Conditional Formatting Make the settings: For Condition 1 Formula is: =A1<"" Click Format button Font tab Blue/Bold OK For Condition 2 Formula is: =A1="" Click Format button Font tab Red/Bold OK Click OK at the main dialog Col D's returned values will be colored blue/red depending on whether col A is not empty (the cond: A1<""), or is empty (cond: A1="") -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "MJK700i" wrote in message ... Hi JulieD, Thank you for replay I have 3 columns, 1st containing empty and non-empty values, 2nd & 3rd containing values. The If function checks the 1st set of data if it is non-empty it gets the results from 2nd set and if it is empty then get the results from the 3rd set. The IF function results give a one column of data. I want to know for each number comes from which set? 2nd set as a blue and 3rd set as a red. Conditional Formatting give a format depends on the number in a cell not from other cell. I am thinking to get a formula like : =IF( A10, [BLUE]B1,[RED]C1) where [BLUE] and [RED] are results with formatting. But that IF statement is not correct. Can you help ! Regards,,, MJK700i |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|