We are using RED color on a date to represent it's a "holiday" or "sunday", while using BLACK color to represent a normal working day.
Just wonder, can I write an IF statement, which is based on the cells' FONT color ?
I quickly made an IF/OR statement but no time to correct it, as i need to go out for a long meeting.
See if anyone can help, thanks in advance.
Normally, all Excel function can do nothing with font or cells attribute (except cell width).
so IF function can do nothing with font or background color.
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Try
=IF(AND(COUNTIF(Holidays!B:B,C7)=0,WEEKDAY(C7,1)>1),"normal","holiday duty")
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
thank you for the formula, this save me a bit of time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks