Hello All,
I would require some conditional formatting insight and help here.
I have values in Col A and some hours in Col B
Col A | Col B
Task 1 | 23
Task 2| 44
How to apply conditional formatting to the entire col –A such that it should fill up with a color if the col B is empty ( col B is formatted as numbers).
The problem is the data is not filled in order. There are several blanks and they don’t have any sequence. How to say when there is a value in B then color Col A. telling the user that Col A is empty and has to be filled because col B has hours in it.
The blank lines with no data are getting colored as well now.
Thanks for reading this post and for your inputs.
I would require some conditional formatting insight and help here.
I have values in Col A and some hours in Col B
Col A | Col B
Task 1 | 23
Task 2| 44
How to apply conditional formatting to the entire col –A such that it should fill up with a color if the col B is empty ( col B is formatted as numbers).
The problem is the data is not filled in order. There are several blanks and they don’t have any sequence. How to say when there is a value in B then color Col A. telling the user that Col A is empty and has to be filled because col B has hours in it.
The blank lines with no data are getting colored as well now.
Thanks for reading this post and for your inputs.