Conditional Format Formula(fun one)

[wickedmosher]

Hello Mr. Excel board members. I have thought up a new challenge I have at work that a specific Conditional Format could fix. I have made great strides in learning Excel, but I still am learning =IF formulas, which is what I think will fix my issue.

Below is a link to my Box.net account containing a download with an example, and all the specifics I need help with. Any help that any of you can give me would be great. And as always, thanks in advance for your help and support with all my Excel learning.


http://www.box.net/shared/yn4yauzrnv

 

[JamesW]

Hi,

It's best if you post a working example in the thread rather than adding a link to a download site, many people do not have access to such sites if they are at work.

 

[SuperFerret]

Maybe in C6:
Conditional Format: Formula Is: =AND(B6=999,C6=0)
Set to Red fill and White font



p.s. I agree with JamesW on the in-thread example

 

[wickedmosher]

When I first started coming to the Mr.Excel board for help, everyone was asking me to post an example on Box.net. Do you know the best way to get my example seen on the board for the next time I have a question?

 

[wickedmosher]

I just tried that =AND formula and it works perfect. Thanks to you both for your help. I will do my best to find a way to get my examples onto the board rather than in a download.

 

[SuperFerret]

There are a few ways, try one of these MrExcel HTML Maker, Excel jeanie or Borders-Copy-Paste

Glad the =AND worked for you