This will probable be simple for someone in the know, but what i am trying to do is if three values (F1 +F2 + F3 )added together are less than a number in another cell D3, i wish to use conditional formatting to highlight the 3 cell (F1-F3)
Conditional Formatting
-
-
Re: Conditional Formatting
Can't see the problem.
CF Formula: =($F$1+$F$2+$F$3)<$D$3
Select F1:F3 before adding the CF and set the formatting as you want.
-
Re: Conditional Formatting
Maybe i should say that wasn't meant as it seems to read . Just meant it's a standard Excel formula, nothing complicated.
If you want to test the formulas used for CF, then you can simply enter them in any cell. The only thing to watch out for is they must return a True/False result.
-
Re: Conditional Formatting
Thanks Grimes0332, you come to my rescue every time
, works a treat.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!