Microsoft Excel - Condition Formating

Asked By Saber on 22-Jun-11 06:15 PM
Hi,

Please help me with below formula.

IF(AND(G7="Successful",F7<=1,"Yes","No"),"")

I need to place above formula in F7 I need to get colours in F7 by using condition formating. My logic is if G7 is successful and  if F7 is Less than 1 or blank I need to get Red Coulour.
pete rainbow replied to Saber on 22-Jun-11 07:13 PM
=AND($G1="Successful",$F1<=1)
Venkat K replied to Saber on 22-Jun-11 10:05 PM
You can also use the Wizard that is provided in Excel to specify the conditions you need:
Check this to get an idea:
http://www.timeatlas.com/5_minute_tips/general/how_to_use_conditional_formatting_to_highlight_data

Jackpot . replied to Saber on 22-Jun-11 10:48 PM
Hi Saber

Your formla is correct except the closing brace position for the conditional statement. Keep in mind that always conditional formattig formula should return either TRUE or FALSE. So you dont require the IF().
Jitendra Faye replied to Saber on 22-Jun-11 11:46 PM
For that you have to use conditional formatting  for your excel sheet.

follow this articale for this-

http://excelsemipro.com/2011/04/excel-tables-styles-conditional-formatting-and-data-validation/

Hope this will help you.
Saber replied to Saber on 23-Jun-11 12:58 AM
Hi All,

Thanks....Its working fine.