Conditional Formatting Help

J

John Adly

Mission:

Trying to have cells under column A turn red if the adjacent B cell is
empty, and is 15 days overdue.


Attempt:

Conditional formatting> =A1+15<=NOW() [Red Font]
Conditional formatting> =A1<B1 [Default Font]

Success!!

Problem:

I want to do the same thing with A2 to B2 A3 to B3 etc....However if I
highlight lets say the entire column, the entire column ill be dependent on
that one cell. I need a way to do this so that each cell react to the cell to
the right just like I did in my example above.
 
B

Brian Morris

Mission:

Trying to have cells under column A turn red if the adjacent B cell is
empty, and is 15 days overdue.

Attempt:

Conditional formatting> =A1+15<=NOW()   [Red Font]
Conditional formatting> =A1<B1                   [Default Font]

Success!!

Problem:

I want to do the same thing with A2 to B2 A3 to B3 etc....However if I
highlight lets say the entire column, the entire column ill be dependent on
that one cell. I need a way to do this so that each cell react to the cell to
the right just like I did in my example above.

Anchor your column with a $...

Conditional formatting>=$A1+15<=NOW()
Conditional formatting>=$A1<$B1
 

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

Top