If Statement
Posted by Jeremy on August 29, 2000 2:11 PM
What would the formula be if I want to highlight a value in column A if there is no value in the same row in column F? Thanks in advance.
Posted by Celia on August 29, 0100 6:37 PM
Jeremy
1.Select cell A1
2.Go to Format>Conditional Formatting
3.Select FormulaIs from the drop down list
4.Enter the following formula : =$F1=""
5.Select Format and choose the format you want
6.Click OK
7.Drag cell A1 down as far as required
Celia
