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