How to automatically fill up a cell when a range of cells are filled up?

O

Ohioan_femme

Joined
Jun 4, 2010
Messages
2
Reaction score
0
I am having trouble with excel. I have searched for hours but I couldn’t seem to find the right formula.

I attached an image of my excel worksheet.

Background:

  • Starting from Row Cells E3 to Z3 are filled up by my colleagues using their initials and date.
  • E2 to Z2 (these are the heading) have a conditional formatting. I don’t know if it matters but I figured I might as well mention it just in case.
What I want to happen:

  • On Column A3, I want it to automatically show ‘OK’ once all the cells in E3 to Z3 are filled up.
  • I want it to show blank if the said cells are not yet filled up.
  • I want this to happen from row 3 down to the end of the data. I know I just have to copy the formula but I am having a hard time creating the formula.
I tried several formulas I found on the internet but they give me the same results whether the row is completely filled up or not.


Thank you very much for the help.
 

Attachments

  • XXXXXXX.JPG
    XXXXXXX.JPG
    100.7 KB · Views: 163

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check 3 cells, only one of the cells my be filled 7
Excel Macro to automatically go to the right of the last colored cell 0
How to Color a Cell Based on a Range of Cells with Colors 1
Checking Filled Columns and Adding up value above 1
Excel Making a cell Mandatory 9
Can i add up all green filled cells in a workbook? 1
Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
exclude certain cells from series fill 1

Top