conditioning

Hi All, So I'm trying to return a value of "Elite", "Athletic", "Average" or "Requires Conditioning" in the formula cell based on single leg jump height in cm (enetered into E69 and F69 compared to a percentage of leg length ($H$4 in the formula). The formula will take the lowest jump height of...

Hi I’m trying to use conditioning in excel as following If the values in column (cost price) is <$49.99 then write down $4.99 as shipping price If the values in column (cost price) is >$49.99, then write down $0.00 as shipping price Applies the rule to the other rows Thank you...

Hi all, I have a document where each supplier is entering their price, I have copied these documents into 1 TAB for each supplier and I want to be able to identify which is the supplier with the cheapest price. i though it was best to highlight a colour from each TAB. The document I am...

Hey, Im trying to make a template with data for my dissertation, im trying to copy the a table and paste in the numbers so it will automatically format the data if it is above or below the a figure generated in the data. I can set up the conditional formatting and paste in the data but when i...

Hello All, I am working in a format where users will input the information, but I need to find a way to make a cell obligatory if there is information in a related cell. For example, if in cell B there is a camp called quantity received, and I need to make cell A obligatory, which is a date...