format cell based on value

  • Thread starter Thread starter macamarr
  • Start date Start date
M

macamarr

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!
 
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)
 
Back
Top