Selecting and highlighting

  • Thread starter Thread starter intheway
  • Start date Start date
I

intheway

Hi all -

What formula can I use in a column to compare a value in another cell
and if the value in the current cell is smaller than the cell i
compares to, then I want it to hightlight that cell- does not matte
what color. Not all cells will have data in the column, so I would onl
like to apply to those cells that have a value in them.

Thanks for your hel
 
Hi intheway!

Lets use A1 as the cell with the base value and B1 as the cell that is
being compared to the base value.

Select the range of cells in column B
Format > Conditional formatting
Formula is drop down
Use the following formula
=AND(B1<$A$1,B1<>"")
Format tab
Select your formatting to taste
OK
OK

Note above that the base value cell is absolutely referenced but that
B1 is relatively referenced
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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 VBA 1
highlighting of cells and columns 1
Highlight duplicate cells based on a selected cell 5
Excel Highlighting duplicates 0
Conditional formatting in Excel 2010 2
VBA Excel partial cell compare to another cell 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
highlight cells that are included in calculated cell 2

Back
Top