Please help Conditional Formating

[aparvez007]

Hi All,


I have below table. i want to highlight data which overlap 7500 which is on hand value.


On Hand Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total

7500 1000 500 600 2500 5000 1000 500 600 700 800 900 250 14350


i.e. jan to apr total is 4600 that means from may to dec should be highlight.

if on hand value is 1500 then Mar to Dec should be highlight.


Thanks

Pavi

 

[oldchippy]

Hi aparvez007,


Select cells B2:M2, go to Conditional formatting > new rule > Use formula... and type in


=SUM($B$2:B2)>$A$2


Then set your formatting

 

[aparvez007]

Thanks oldchippy...


I used this one... also working.

tell me if i made mistake on below formula.

=IF(SUM($B$2:B$2)>$A$2,1,0)


Thanks

Pavi

 

[oldchippy]

Hi,


With CF you don't need to type in the IF part of the formula, just the condition. Although it still work's even if you do include the IF formula. You can see that the condition inside yours is the same as mine, although you have included the $ sign to fix it to row 2 only.

 

[aparvez007]

Thanks for your kind explaination next time i will remember dear oldchippy.

once again thanks alot.


Regards,

Pavi