format cell based on value
 

Hello, I tried some basic if, then's but I must be doing
it wrong.... I need to have cell d5 font color to be white
if d3 and d4 values are both 0. If they are not both 0
then I need d5 font color to be black. thanks!

format cell based on value
 

Read "Conditional Formatting" from the help files.

-----Original Message-----
Hello, I tried some basic if, then's but I must be doing
it wrong.... I need to have cell d5 font color to be
white
if d3 and d4 values are both 0. If they are not both 0
then I need d5 font color to be black. thanks!


.

format cell based on value
 

Mac,

Use conditional formatting, with a formula of =AND(D3=0,D4=0), and set the
format font colour to white.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"macamarr" wrote in message
...
Hello, I tried some basic if, then's but I must be doing
it wrong.... I need to have cell d5 font color to be white
if d3 and d4 values are both 0. If they are not both 0
then I need d5 font color to be black. thanks!