Conditional Formatting

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
Hi all,

I am trying to highlight the cells for all client names (Column A) on a spreadsheet where the amounts entered (Column B) equals $0.00.

Can anyone advise on how I could do this? Is it easy?

Many thx in advance.

Gary
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139

ADVERTISEMENT

Sorry Glenn, idiots guide required here - First time I've tried this.

Do I have to highlight the cells in column A first? Doesn't seem to be working.
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
What cells did you select before choosing menu command Format/Conditional Formatting? I assumed you'd be selecting column A or at least cells from column A ( range A1:A99 maybe? )?

Did you use my exact formula? Please paste the formula you used in your reply.
 

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139

ADVERTISEMENT

OK.

Firstly I selected the following range from column A (A5:A200) - These are the client names that I would like to highlight when the value is 0.

Then I went to Format -> Conditional Formatting:

FORMULA IS : $D5=0 (D5:D200 - being the value fields where 0 is the trigger)

From format I choose to bold the text and colour the cell.

Hope this is clear ;->
 

Forum statistics

Threads
1,136,309
Messages
5,674,999
Members
419,541
Latest member
freddyboots

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