A Simple conditional format

c hassett

New Member
Joined
Jul 17, 2007
Messages
27
This is driving me nuts. :x It should be simple but I can't seem to get it to work or find the a thread with a working solution.
I have rows with dates in of the days of the week, ie B20 23Jul07 to F20 27Jul07 then row 21 with 30Jul07 to 03Aug07.
I want to conditionally format each row so that when the date in B2 TODAY() equals the date in the specific row the type becomes BOLD.
All I'm missing is the formula to get it to do that.
I've tried selecting the row, conditional formatting, Formula is =$B$2 and =TODAY().
Also tried IF with $B$2=B20:F20
I must have taken my stupid pills this morning.
Thanks in advance for your help.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Select your entire range of dates, e.g. B20:F30 and use formula

=($B$2>=$B20)*($B$2<=$F20)

edit: there are several other ways e.g.

=OR($B$2=$B20:$F20)
 
Upvote 0

Forum statistics

Threads
1,222,043
Messages
6,163,561
Members
451,844
Latest member
ddnndd1234

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top