Hi all,
I have had a spreadsheet working for weeks and now I have amended it to add another staff member my conditional formatting has broken. I have tried taking it out and re-aplying it but still no fix.
The way I am applying this is
Format>Conditional Formatting
Call value is>less than or equal to>format red.
This is being applied to a column of cells and applied in column S and the less than or equal to is the number in column T. Is does go red if it is less than but not equal to.
Can anyone help as I'm going insane!!
Thanks
Bookmarks