View Single Post
  #5   Report Post  
Micayla Bergen
 
Posts: n/a
Default

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