Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
#2
![]() |
|||
|
|||
![]()
formatconditional formatting, formula is
=AND(ISNUMBER($A5),$A50) if you know there can never be text in A you can shorten that to =$A50 regards, Peo Sjoblom "Steve R" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
Highlite a row | Excel Worksheet Functions |