help with IF statement.
You can accomplish this by using a conditional format (short cut keys
ALT O D). Use the "formula is" option, not the "cell value is". be
sure to be in the cell or have highlighted the cells you want to
conditionally format first, then define the conditional format for that
cell or cells. In the blank box type "= True". then choose the format
you want for text and cell. Once you have defined a cell with a
conditional format, you can copy and paste special format to another
cell.
Hope this helps.
Sean
|