Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional format greater or less than
can i make a formula to change the format of the cell if it is 2 or 1? i have
tried IF FIND and less than greater than but have had no luck thus far thanks |
#2
|
|||
|
|||
Look in conditional formatting. Under format. You can change the fontcolor
textboder of the cell with conditions that you set. Pat "Micayla Bergen" wrote: can i make a formula to change the format of the cell if it is 2 or 1? i have tried IF FIND and less than greater than but have had no luck thus far thanks |
#3
|
|||
|
|||
I am in conditional formatting, and would like to have the formula for the
condition only if the cell value is either 2 or 1, but am not sure how to word it correctly "patrick" wrote: Look in conditional formatting. Under format. You can change the fontcolor textboder of the cell with conditions that you set. Pat "Micayla Bergen" wrote: can i make a formula to change the format of the cell if it is 2 or 1? i have tried IF FIND and less than greater than but have had no luck thus far thanks |
#4
|
|||
|
|||
Use formula is and
=OR(A1=1.A1=2) where A1 is the cell with the formatting -- Regards, Peo Sjoblom "Micayla Bergen" wrote in message ... I am in conditional formatting, and would like to have the formula for the condition only if the cell value is either 2 or 1, but am not sure how to word it correctly "patrick" wrote: Look in conditional formatting. Under format. You can change the fontcolor textboder of the cell with conditions that you set. Pat "Micayla Bergen" wrote: can i make a formula to change the format of the cell if it is 2 or 1? i have tried IF FIND and less than greater than but have had no luck thus far thanks |
#5
|
|||
|
|||
Thank you!
"Peo Sjoblom" wrote: Use formula is and =OR(A1=1.A1=2) where A1 is the cell with the formatting -- Regards, Peo Sjoblom "Micayla Bergen" wrote in message ... I am in conditional formatting, and would like to have the formula for the condition only if the cell value is either 2 or 1, but am not sure how to word it correctly "patrick" wrote: Look in conditional formatting. Under format. You can change the fontcolor textboder of the cell with conditions that you set. Pat "Micayla Bergen" wrote: can i make a formula to change the format of the cell if it is 2 or 1? i have tried IF FIND and less than greater than but have had no luck thus far thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
conditional format | Excel Worksheet Functions | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |