I am not necessarily a newby but not familiar with conditional formatting, have searched but cant find an answer.
I have 2 columns for my first aid column 1 lets say b14 has a value of the amount of items eg #15 wound dressing 2 and D14 shows how many are left 1 I want to highlight D14 if the cell value is less than the cell value of B14.
There are 30 plus cells in the column and most numbers are different as with column D so do I need to format each cell or can I format column D to highlight if the number is less than the corresponding cell from column b
Bookmarks