Can you use If/Then Formulas in Conjunction with Conditional Formatting?

[Heyna]

Hiya.
I'm trying to come up with a way to make a group of cells follow
conditional formatting command (change of font to bold, color change t
cell) motivated by a single validation cell: in other words, I have
long list of prospective contractors with bid information, and I'v
made a validated cell a pull-down menu that simply states "awarded".
can make the validated cell follow a conditional format, but there ar
many, many different workstages, and each of those has many prospectiv
contractors, so it would be wonderful if i were able to make all th
cells that contain info conditionally format to "pop" from al the othe
data. Am I over thinking this? I'm trying to make this ver
user-friendly for construction guys who do not know Excel (yes, I'
protecting my formulas-LOL)
Any help would be greatly appreciated

 

[Frank Kabel]

Hi
this is probably me but I did not get what you're trying to achieve.
What do you mean with 'pop from all the cells'
You may give an example for this

 

[Heyna]

Bad choice of words on my part. i meant that it would look differentl
than the other cells by changing color, font, or "pop out" as in "catc
the yey". I'm trying to devise a way to make data in certain cell
conditionally format if a formula in another cell (which is a validate
cell with a scroll-down list basically saying "YES"). If this validate
cell has text in it, i wanted cells associated with it (Data Entr
Cells) to change color; that person and data was picked to get the job
so it gets a color to it.
I hope I made it a little clearer.
Is there an easy way to do that

 

[Frank Kabel]

Hi
still not quite sure. But if you want to color cell B1 based on the
entry in cell A1 try the following
- select cell B1
- goto 'format - Conditional Format'
- enter the formula
=A1="Yes"
- choose a format

 

[Heyna]

That worked perfectly! Thank you much! As usual,
I was overthinking the problem