Conditional Formating comparing the two columns

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

If column "A2" is less than the value in column "B2" I want to change the
color of "A2"
 
Select the range, eg A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<B2,ISNUMBER(B2))
Format to taste > Ok out

The ISNUMBER(B2) is an additional precaution
to avoid spurious triggers caused by possible text entries in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
 
Thanks Max works like a charm.

Max said:
Select the range, eg A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<B2,ISNUMBER(B2))
Format to taste > Ok out

The ISNUMBER(B2) is an additional precaution
to avoid spurious triggers caused by possible text entries in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
Click to expand...
 
You must log in or register to reply here.

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 conditional formatting with Weeknum 4
Conditional Formatting Applying Rule to Entire Column 2
Excel Conditional Formatting 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
value in cell B < value in cell A conditional format 3
conditional formatting formula to highlight items on column B inrelation to column A 3
compare columns and rows 4
conditional formatting dependent of preceding cell 1

Back
Top