• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting based on another cell value

vpxlquest

Member
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.
 
Selecting col A, with cell A2 active, conditional format formula is:

=AND($A2<>"",$B2<>"")


This will highlight any cells where col B is not blank and there is still nothing in col A.
 
I use excel 2007

I have selected use a formula to determine which cells to format

Can I use the formula for a range of cells like this

=AND($C12:$C200 <> "",$D12:$D200 <>"") format some color.

Thanks again.
 
No, don't put the whole range in the formula. You can select the entire range, and then apply the formula however, as long as you don't make the row reference an absolute (don't put the dollar sign in front of row number). Then you just need to make the formula refer to whichever cell is currently active (which cell you would currently type in)
 
Back
Top