If And

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with conditional formatting. I have 3 cells with numbers in them.
A1, B1, C1 I want it to color A1 if the number in A1 is greater than the
number in B1 And C1. Any ideas? Thanks
 
Hi Matt

click on A1
choose format / conditional formatting
choose formula is
type
=AND($A1>$B1,$A1>$C1)
click on the format button / choose a format
this is cause A1 to change colour if it is greater than BOTH B1 & C1
if you want it to change if it is greater than either, change the AND to an
OR

Cheers
JulieD
 
Back
Top