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

  • Thread starter Thread starter Heyna
  • Start date Start date
H

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