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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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)
 

c hassett

New Member
Joined
Jul 17, 2007
Messages
27
It work!!!!!!!
A million thankyous, I knew it wasn't to complicated a task but I was just blank.
 

Forum statistics

Threads
1,181,730
Messages
5,931,707
Members
436,799
Latest member
BasOo

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
Top