Conditional formating

cains

New Member
Joined
Sep 12, 2006
Messages
23
Hi all....

Just found this forum... Can see i have a lot to learn... :rolleyes:
Im 29years old, from denmark.. Have used Excel for 5 years or so.. Would say im above avr. in user level.. But now i have a problem i can not solve.. :(

So im trying here...

Heres is what i have:

A5 = there is some text.
I want to make a conditional format in this cell, where i want to see if B5=C5
then A5 text has to be BOLD

Thats what i want.. B5 and C5 is both date
A5 is just normal text...

Thx in advance.. :)
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

In A5-->Conditional Formatting-->Formula Is-->=B5=C5. Format as necessary.

Hope that helps,

Smitty
 

cains

New Member
Joined
Sep 12, 2006
Messages
23
THANX!!!! :LOL:

That was so easy....

Here what i tried first. =if(b5=c5)
but that didnt work.. So thats why i failed...

First experience with formulas in conditional formating, but not the last. :biggrin:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,130
Messages
5,857,550
Members
431,885
Latest member
Rsdg

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