Microsoft Excel - Condition Formating
Asked By Saber on 22-Jun-11 06:15 PM
Please help me with below formula.
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
Venkat K replied to Saber on 22-Jun-11 10:05 PM
Jackpot . replied to Saber on 22-Jun-11 10:48 PM
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
Saber replied to Saber on 23-Jun-11 12:58 AM
Thanks....Its working fine.