MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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