Hello,
Need a pointer on an excel issue.
i have a column where I input a value into and if it goes above a certain number, i need it to be highlighted a color.
The cell is highlighted if the number is above, for example 1400......
the catch is that we also add the date into this cell after the number, like this------------------1400(7/2/2018) and i just need it to look at the 1400 number and nothing else.
I can set this up in conditional formatting and it works but not with the date and losing the date is not something I can do.
thanks,
Z
Bookmarks