Hi there,
I am trying to make a condition so that if a cell DOES NOT total to .00, .25, .50, .75 that the cell goes a colour (ideally yellow with red font).
I thought I found a formula to use in conditional formatting, =FLOOR(F9,0.25)<>F9 , but it does not work every time.
Are there any other suggestions out there? I have attached a copy of the sheet I am working with.
Thanks for any help anyone can provide!
Amanda
Bookmarks