If then highlite?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to conditional format cells based on other cells?

In other words, is there a way to have cell B5 to turn red if cell A5 has a
number greater than 0?

I just want it to work so when someone enters a quantity in column A, that
the Cost cell highlites in column B to remind them to enter a cost.

THANKS!
 
format>conditional formatting, formula is

=AND(ISNUMBER($A5),$A5>0)

if you know there can never be text in A you can shorten that to

=$A5>0

regards,

Peo Sjoblom
 

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

Formula to count Highlited Cells. 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
How can I highlite an entire row using conditional formatting? 4
Change Text Color in one cell based upon entry in referenced cell 3
problem filling in blank cells with data above - 1
sumproduct or sumif? 3
Conditional Formatting - Excel 2003 2
if statement 2

Back
Top