Conditional Formating

[rizmomin]

Hello:

I have data in Column D.
Depending on the value in cell Q1, I need to apply conditional formatting as below.

If the value of any cell in column D is > or equal to Q1 then highlight.

Let me Know if you have any questions.
Thanks.



Riz

[nathansav]

Formula based conditional formatting =countif(D:D,q1)>0 as the condition

[Kaper]

Use a conditional formatting rule based on formula.
The one for you is probably somethimmg like:

Please Login or Register  to view this content.

[Kaper]

@ nathansav - if with countif then probably rather

Please Login or Register  to view this content.

[rizmomin]

Hello:

The above does not work.
Example D4=82 and Q1 is 80.
In this case, it should highlight D4 but it does not.

Let me Know if you have any questions.
Thanks.


Riz

[nathansav]

@Kaper sorry missed the > in the OP.

[rizmomin]

Hello:

Please find attached sheet with example.
I need to highlight cell D3,D12,D16 as the value in Q1 is 80.

Let me Know if you have any questions.
Thanks.



Riz

[Ace_XL]

Select range D2:D16

In CF use

=D2>=$Q$1

format --colour

[rizmomin]

Hello Ace_XL:

Works great, thanks

Riz