How to automatically change cell color based on another cells conditional formatting?

[jayemoh77]

A	B	C
3.50	4

<tbody>
</tbody>

I have conditional formatting in column A to change the color of the cell to red if the number is 3.50 or greater. How can I make column B just copy whatever color cell column A is?

Happy Friday!
Thanks,
Julie

 

[Joe4]

Just apply the same Conditional Formatting that you are using in Column A.
You can actually do both columns at once with a single CF rule if you use the Formula option.
So, select columns A and B, and apply this formula:

=$A1>=3.50

and select your red color.

 

[Scott T]

With the cell you want to conditionally format selected

in Conditional formatting select new
then select use a formula to determine which cells to format
then use

=$A1>=3.5

select your formatting

 

[jayemoh77]

Heres the problem with that
A is a prevalence rate in which over 3.50 will be red
B is the number of occurrences something happened and can be anything from 0-50
in many cases my prevalence rate can be 2.3 and number in column B is over 3.
im not sure how to tell column B to just do what column A does.

 

[Scott T]

The above replies. In conditional formatting you are looking at what is in column A even if you are formatting column B.

 

[Joe4]

What Scott said...

Note that we both put a dollar sign in front of the column reference ($A).
That tells it no matter what column you are in, check the value in column A.
Try it for yourself. Follow the step-by-step instructions I gave you exactly, and you will see!

 

[jayemoh77]

IT WORKS!
You're the best!!!!!!!! Thank you!!!