View Single Post
  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi Lee

you can use conditional formatting on the "another cell"
e.g.
click on the cell
choose format / conditional formatting
choose
formula is
type something along the lines of
=AND(A1=10,B1=5)
click the format button - choose your formatting
and click OK twice

- if you'ld like more assistance please post back the cell reference of the
"two" cells and the "certain combination" that you want to test for.

Cheers
JulieD

"Lee" wrote in message
...
Does anyone know of a way to check for a value in two different cells, and
if
a certain combination of values exists, change the format of another cell?

Any help would be much appreciated.

Thank You.