cell formatting based on "IF" statements

jpf5911

Board Regular
Joined
Jun 10, 2002
Messages
72
I have a section of a sheet where I only want certain data to display based on other data in the sheet. So, I am using "IF" statements. This works fine except that I would like a portion of the data surrounded by a box (Cell borders) and a portion is a column of numbers that are summed up so I also want a double underline at the bottom.

If I format the cells to create the borders and the double underline, then the borders exist even when no data is there.

How do I tie these formatting choices to an "IF" statement?

Thanks OH GREAT EXCEL WIZARDS.

JPF
 

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.

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi JPF,

How about using Conditional Formatting?

(Format menu item, then Conditional Formatting)

HTH
 

jpf5911

Board Regular
Joined
Jun 10, 2002
Messages
72
Hmmm, that's pretty close, and I didn't know about that feature. However, it won't completely do the trick since I want to make a cells formatting conditional upon the value of a different cell, not the cell itself.

Thanks,

JPF
 

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
You are on the right track. But instead of using "Cell Value Is" in the first drop down box, choose "Value Is" and put in:

$A$1=1

where A1 is the cell that drives the formatting and the "1" is your target value.
 

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi,

I'm sure this can be done. Try using the search facility (top right) and check previous posts on conditional formatting.

(Sorry I can't give a direct solution myself - I can't remember the method :wink: )
 

jpf5911

Board Regular
Joined
Jun 10, 2002
Messages
72
OF COURSE!!!!

It's amazing how you can be an "expert" level Excel user with years of experience and still learn something new.

Thanks,

JPF
 

Forum statistics

Threads
1,148,526
Messages
5,747,216
Members
424,069
Latest member
kamkwok1hh

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