conditional formatting for office 2003

August 31, 2009 at 21:07:16
Specs: Windows XP
I have only two conditions to format.for few cells both the conditions have to be true. Its not working for those cells. my formula for 1 st condition is
=OR($C$12="MRAM",$C$12="FRAM") then formatting
=$C$34="NO" then same formatting. this should work regardless of first condition.

I tried with manyother formula nothing seems to work kindly help!!

Do i need to write macro to make it workable. I am very new to VB.
Thanks in advance.


See More: conditional formatting for office 2003

Report •


#1
September 1, 2009 at 06:23:31
Is this what you are looking for?

=IF($C$34="NO",TRUE,IF(OR($C$12="MRAM",$C$12="FRAM"),TRUE,FALSE))

P.S. For ease of testing, you can put the formula in a cell and try your conditions, looking for TRUE and FALSE results.

That might make it easier to troubleshoot vs. editing it in the Conditional Formatting dialog box. You can also use the Evaluate Formula feature when the formula is in a cell.


Report •

#2
September 2, 2009 at 22:58:40
HI derby,

Thank you very much for responding..

i explain my problem..

for C12 cell if the option is FRAM or MRAM.. i want to format

B24:C31 and E27:F31

if cell C27="no" then i want to format E27:F27 similarly for cell C28="no" format E28:F28
cell C29="no" format E29:F29
cell C30="no" format E30:E30
cell C31="no" format E31:F31

i tried almost 4 formulas all are working but cells E28:F30 is not working due to overlapping problem.

these are not working: once i save it i want these features in both in excel 2003 and 2007, in 2003 it allows only 3 conditions...

C27="no" then i want to format E27:F27 similarly for cell C28="no" format E28:F28
cell C29="no" format E29:F29
cell C30="no" format E30:E30
cell C31="no" format E31:F31

Only 1 condition is working fine

=OR($C$12="MRAM",$C$12="FRAM")

i tried your formula its working only for 1 option that is mram fram...so i tried to change formula based on prioroity like this its throwing me error saying formula is wrong.. here is the formula i changed..

=IF(OR($C$12="MRAM",$C$12="FRAM"),TRUE,IF($C$34="NO"),TRUE,FALSE))

kindly help.


Report •

#3
September 3, 2009 at 00:41:31
i have put separate formula for Yes/No cells also. that formula is

=$C$27="NO" then format also i tried with

=IF($C$27="NO",TRUE,FALSE)

I think putting only one formula for all the cells is the best solution as you have given. I am trying to avoid conditional overlapping.Please help me i am fresher and new to excel and VBA.

Thank you very much in advance


Report •

Related Solutions

#4
September 7, 2009 at 05:24:40
Hi,

i tried with this formula still i few cells are not working but i am not getting warnings also.. this is the formula i used.

=IF(OR($C$12="MRAM",$C$12="FRAM"),TRUE,IF($C27="NO",TRUE,FALSE))

actually all cells are working but for few cells when the excel is opened few cells are not working.

Is there any way resolve this issue i am trying this since 2 weeks with many formulas with no success.


Report •

#5
September 7, 2009 at 08:33:53
re: actually all cells are working but for few cells when the excel is opened few cells are not working.

Care to explain this statement? Either all cells are working or they're not.

In response 2 you said: i want to format B24:C31 and E27:F31

However, your examples only give specifics about the E:F ranges, nothing about B24:C31. That's a little confusing, at least to me.

Maybe I'm missing something in your requirements. Which of these are you looking for:

1 - Two different formats, e.g. fill yellow if Cxx = No and fill Blue if $C$12 = NRAM or FRAM with the No overriding whatever is in $C$12.

or

2 - One format, e.g. fill yellow if Cxx = No and fill Yellow if $C$12 = NRAM or FRAM with the No overriding whatever is in $C$12.

3 - Something totally different?

The difference here is that two formats require 2 conditions in the CF wizard, with 2 different formula and the one format can be done with 1 condition, 1 formula.

Please tell us which of those you are looking for.


Report •

#6
September 7, 2009 at 08:34:12
Hi

I'm not sure if I've fully understood your question, but I think your problem might be with how you're copying the formatting. To do this:
C27="no" then i want to format E27:F27 similarly for cell C28="no" format E28:F28
highlight celss E27:F27 and select conditional formatting. Change the left most option to formula is, and type in =IF($C27="no",TRUE,FALSE) then add your format. (NOTE there is no $ before the cell number). If you then copy E27:F27, highlight the rest of the cells you want to format, and select paste special and select formats, because there is no $ infront of the cell number, the fomula should always look at column C on same the row of the formatted cells ...

I'm not sure if that makes sense, but I hope it helps.


Report •


Ask Question