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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Welcome to the Board!

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

Hope that helps,

Smitty
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,214,561
Messages
6,120,234
Members
448,951
Latest member
jennlynn

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