| 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 | |||
Hybrid Mode
