AND in formula in conditional formatting not working

H

Hudco

Board Regular
Joined
Jan 4, 2006
Messages
127
Office Version
  1. 365
Good Evening everyone,
I have two cells, lets say G10 and H10, with a formula (say =G4-(SUM(G6:G9) ) and the second cell is exactly the same formula but referencing the next column.

Then in cell F10 I have a formula generating text based on the results of G10 and H10. All these formula are working correctly. But I have set a conditional format to apply to F10 such that if G10 AND H10 are zero then the text in F10 is to be red and bolded. The conditional Format formula is ="AND(G10=0,H10=0)" but when G10 and H10 are zero the text colour does not change.

Can anyone shed some light on what might be wrong.

Thanks.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
Does your CF formula include the quotes?
If so remove them
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

R
  • Question Question
Why does the the following Formula Work if the Result is Displayed in Next To Adjacent Column ?
2
Replies
11
Views
838
etaf
etaf
J
  • Solved
conditional formatting formula based on what day of the week
Replies
3
Views
590
awoohaw
awoohaw
T
  • Question Question
Open CSV with VBA, convert to ANSI and a cell "75 %" is changed to format type percent and the value is changed to "0.75"
Replies
1
Views
348
Tanquen
T
V
  • Solved
Copy only Value not Formula to new Cell location after ActiveX Macro button pushed.
Replies
2
Views
162
VinnyDoesntKnowExcelCode
V
S
  • Solved
Conditional Formatting
Replies
3
Views
64
Fluff
Fluff

Forum statistics

Threads
1,223,908
Messages
6,175,307
Members
452,633
Latest member
DougMo

Share this page

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