Hello All
If I have any cell in column F that is blank, then that cell will be a light red color fill. However, I need the conditional to cover all cells in column F. The problem I'm having is if I use the Conditional Blank rule, it makes all blank cells light red. I just want to go one row at a time.
Example:
lets say no data is in F23, then F23 will be filled with light red. When data is entered in F23, the color goes away. However, rows 24:to the bottom, column F will remain blank, until an entry is placed in Column B, then the cell in column F will turn to light red, until an entry is placed in that particular Column F cell.
Thanks
If I have any cell in column F that is blank, then that cell will be a light red color fill. However, I need the conditional to cover all cells in column F. The problem I'm having is if I use the Conditional Blank rule, it makes all blank cells light red. I just want to go one row at a time.
Example:
lets say no data is in F23, then F23 will be filled with light red. When data is entered in F23, the color goes away. However, rows 24:to the bottom, column F will remain blank, until an entry is placed in Column B, then the cell in column F will turn to light red, until an entry is placed in that particular Column F cell.
Thanks