Hello
Please help me for this problem:
In column A I have a time like
8:40
in column B I may have either "CL", or "LFT"
I want to make column A value bold if time is greater than 8:30 and also
1)IF Column B contains text other than "CL", or "LFT" or " "
Best Regards
Imran Bhatti
Teach me Excel VBA
You can use this formula in the Conditional Formatting dialogue box for cell A1:
=AND($A1>TIME(8,30,0),$B1<>"CL",$B1<>"LFT",$B1<>" ")
Hope this helps.
Pete
Thank you very much Pete....I got the desired results with this...and thanks to format painter who pasted the formating to other rows.
Thread is (SOLVED)
Best Regards
Imran Bhatti
Last edited by ImranBhatti; 10-16-2016 at 02:39 PM.
You're welcome - thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks