can anyone tell me the formula I need to enter if I have a cell test which is
"flat" then turn a different cell yellow?
--
SandyB

on conditional format change to "the formula is" and use a formula

=if(a110)
format as your needs

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"SandyB" escreveu:

can anyone tell me the formula I need to enter if I have a cell test which is
"flat" then turn a different cell yellow?
--
SandyB

test which is "flat"? Please explain.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"SandyB" wrote in message
...
can anyone tell me the formula I need to enter if I have a cell test which
is
"flat" then turn a different cell yellow?
--
SandyB

Apparently my typing skills are lacking a bit. it should have said text which
is "flat"
I actually have 6 different text choices for a column, and based on which
text is used, other various cells need to turn yellow indicating these need
filled in by the user. That is what I am trying to accomplish.

Thank you so much!!
--
SandyB


"Bob Phillips" wrote:

test which is "flat"? Please explain.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"SandyB" wrote in message
...
can anyone tell me the formula I need to enter if I have a cell test which
is
"flat" then turn a different cell yellow?
--
SandyB