基于天数突出显示一系列单元格。 - 擅长 [英] Highlighting a range of cells based on days off. - excel
本文介绍了基于天数突出显示一系列单元格。 - 擅长的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
= OR(LEFT(TEXT(B $ 5,ddd),2)= LEFT($ L $ 2,2),LEFT(TEXT(B $ 5,ddd),2)= LEFT($ M $ 2,2))
我哪里错了?休息日为文本格式。
解决方案
请尝试以下公式。希望它有效。
= OR(LEFT(TEXT($ B5,ddd),3)= LEFT(TEXT $ L $ 2,DDDD),3),LEFT(TEXT($ B5,ddd),3)= LEFT(TEXT($ M $ 2,DDDD),3))
下面放置的临时工作屏幕截图。
I already got some help with this before, and had it working. Since, I have flipped the orientation of my schedule and instead of going across it is now going down. And this conditional formatting no longer works.
=OR(LEFT(TEXT(B$5,"ddd"),2)=LEFT($L$2,2),LEFT(TEXT(B$5,"ddd"),2)=LEFT($M$2,2))
Where am I going wrong? The days off are in text format.
解决方案
Please try the following formula. Hope it works.
=OR(LEFT(TEXT($B5,"ddd"),3)=LEFT(TEXT($L$2,"DDDD"),3),LEFT(TEXT($B5,"ddd"),3)=LEFT(TEXT($M$2,"DDDD"),3))
Temporary working screen shot placed below.
这篇关于基于天数突出显示一系列单元格。 - 擅长的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文