Change Line color based on 2 different cells
 

I'm trying to change the line color to red based on data from two
different cells. An example would be if one cell is less than 6 months
of time and training hours needed is greater than 0 then turn the line
red. Conditional formatting won't work because of two different cells?

Thank you! Mitch

Change Line color based on 2 different cells
 

You can still use Conditional Formatting. Just use the AND function.

Not sure what your actual data/formulas are, but you should be able to apply
them using the following formula:

=AND($A$1<6,$B$10)

HTH,
Elkar



"lawdoggy" wrote:

I'm trying to change the line color to red based on data from two
different cells. An example would be if one cell is less than 6 months
of time and training hours needed is greater than 0 then turn the line
red. Conditional formatting won't work because of two different cells?

Thank you! Mitch

Change Line color based on 2 different cells
 

Thanks for the reply. I didn't specify clearly I want to change the
entire row color based on two different cell values. I can't figure out
how to use conditional formating on based on two different cell data
points? I can use conditional formatting on one cell with many
different conditions but that would accomplish the row color. I think I
might need a little VB code?

Thanks...Mitch

Change Line color based on 2 different cells
 

Never mind I figured it out thanks to the first reply. Thank you!

Change Line color based on 2 different cells
 

You should still be able to accomplish this. Just select your entire row,
then set the Conditional Formatting. Change "Cell Value Is" to "Formula Is".
Then enter the formula (adjust to your needs):

=AND($A$1<6,$B$10)

Set your format. Click OK.

The use of Absolute Cell Referencing ($A$1 instead of A1) will prevent the
formula from incrementing across the entire row, allowing those 2 cells to be
referenced by the entire row.

If this isn't what you're looking for, then post back with more specific
details/example of what you want.

HTH,
Elkar


"lawdoggy" wrote:

Thanks for the reply. I didn't specify clearly I want to change the
entire row color based on two different cell values. I can't figure out
how to use conditional formating on based on two different cell data
points? I can use conditional formatting on one cell with many
different conditions but that would accomplish the row color. I think I
might need a little VB code?

Thanks...Mitch