Various conditional formatting questions!

[AmyT148]

Hi all,



I’m wondering if you can help me with a few queries. I am putting together a spreadsheet with various tabs to show the stock levels of supplies in our office and am struggling with a few things I’m almost certain can be done (I think I’ve even done them before!) but I just can’t suss it so I’m hoping you might be able to help!



I am wanting the following:

• A table with a cell on a separate tab to pull through if orders are outstanding, basically where there is a ‘No’ in columns F, J, N, R, V on the other tabs I want a 'yes' in this cell
• Conditional formatting to fill a cell if the number in column E is either less than (red) or equal/greater (green) than a number in column B (I can do this for single cells but would be ideal to be able to apply it to each row in one go, so linking B2 and E2 then B3 and E3 etc without having to do separate rules on each cell).
• Conditional formatting so a date prior to today (whatever date I open the spreadsheet) will turn red

Many thanks in advance!



Amy

 

[AmyT148]

Oh, I'm on Microsoft 365 if that makes a difference at all?!