Conditional Formatting - when cell part meets target

[sandwichgirl]

Another help question that I'd like to see if possible please?

I have conditional formatting that colours a cell if the value of the cell is fully covered by the available stock - I have no problem with this, it all works well, but, the following cell which is currently white, may be partially covered with the stock, but currently shows as not covered at all - is there a way to set up CF so that it has a fill effect (orange/white) to indicate that the stock partially covers that volume?

I've included a screen grab of the current CF formula and how it shows on the sheet.

TIA, again.

 

[jasonb75]

A clue as to what AG6, O7 and S7 refer to would be useful. There is nothing to tell us which is the current stock level and which is the value of interest to compare to.

Typically the formula would be =AND(stock>0, stock<order)

 

[sandwichgirl]

A clue as to what AG6, O7 and S7 refer to would be useful. There is nothing to tell us which is the current stock level and which is the value of interest to compare to.

Typically the formula would be =AND(stock>0, stock<order)

Whoops sorry, here you go.

A screen shot showing a wider area - I can't do a mini sheet unfortunately. The formatting is based on dates which are calculated based on stock volume vs forecasted volume, so when the date tips into the next week ie 22/12 I'm trying to see if I can fill that cell to indicate a partial coverage. It's a big sheet so there are some hidden columns that don't impact on this query.

The forecast is updated twice a week (Tue/Thur) which drives the week dates so they don't follow a more usual start day and as an example I'd like to see if I can shade AO17 to show that the stock carries on into this week.

Hope this makes sense and Thank you.

 

[jasonb75]

For AG7, something like this should work

=AND(AG$6<$S7,AG$6>$S7-7)

You may need to play around with the adjustments adding to / subtracting from $S7 to get exactly what you want depending on the correct day for the cut off.

 

[sandwichgirl]

For AG7, something like this should work

=AND(AG$6<$S7,AG$6>$S7-7)

You may need to play around with the adjustments adding to / subtracting from $S7 to get exactly what you want depending on the correct day for the cut off.

fab, thank you - just the job.