Day wise RM coverage

[rajmata]

Hello all,
I want to create daily RM coverage file

So, column A has the item master list, column B has current stock and from column C to AG has day wise requirements, now the exact requirement which will fall short should be highlighted as per the current stock value.
example as given below

 

[alansidman]

No example shown. Use XL2BB to show data and expected results mocked up. No pictures as we cannot manipulate data in a picture.

 

[kvsrinivasamurthy]

Select the range C2: I8 (as per image), Change the range as required.
Hoe --> Conditional Formatting --> New rule
Select Use a formula....
Enter the formula and select the required formatting.

=SUM($C2:C2)>$B2

 

[rajmata]

Select the range C2: I8 (as per image), Change the range as required.
Hoe --> Conditional Formatting --> New rule
Select Use a formula....
Enter the formula and select the required formatting.

=SUM($C2:C2)>$B2

Yes it's working, Thanks for the solution.