im trying to highlighted Cells where the cheque number is greater or equal to 1000
but it highlights all cells
(See Attachment)
because of the nature of the book i cant upload any more screen shots
TIA
im trying to highlighted Cells where the cheque number is greater or equal to 1000
but it highlights all cells
(See Attachment)
because of the nature of the book i cant upload any more screen shots
TIA
Maybe
=and(C5<>"EFT",C5>=1000)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks