Highlight cells based on conditions

V

Vic

I need to highlight cell B if it is greater than cell C of the same row,
providing that cell C is NOT blank. All cells formated as date.

Thank you.
 
C

Cornelia

I had this type of question answered on 4/28/09 in the Excel Function
questions.
Title is "Change Colr on rows, after and IF Funtion is answered"

You would use the Conditional Formatting on the cell.
 
G

Gary''s Student

Format > Conditional Formatting... > FormulaIs >

=AND(C1<>"",B1>C1) and pick a nice background color
 
S

Sri

I need to highlight cell B if it is greater than cell C of the same row,
providing that cell C is NOT blank. All cells formated as date.

Thank you.
Click to expand...

You can use conditional formatting for this. Select Column B -> Go to
Format -> Conditional formatting -> Cell is -> Greater than -> ... I
think you can proceed from here. Just change the format to highlight B.
 

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

Excel Highlighting duplicates 0
Highlight MAX Cell Greater Than Zero 4
Excel Typed text appears in wrong cell 0
Conditional Formatting based on 2 conditions 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
conditional formatting date and blank cell 3

Top