Conditional formatting formulae

[Potholes]

Good evening

I have 2 cells to conditional format.

If Cell Q6 has (14:50) (Time)

H6 is the cell to be Cond formatted

If cell H6 reads if Q6 has something in it, and if Cell H6 is displaying any number below 4, then display "ERROR" else blank H6
On the error It is at this point the H6 will be filled with Red with White font.

Please Login or Register  to view this content.

[AliGW]

Q6 is not bigger than one - 14:50 is a fraction of time that equates to 0.618055555555556.

Perhaps if you change the test to either bigger than 0 or not equal to blank, so your CF rule would be:

=AND($Q6>0,$H6<4)

or:

=AND($Q6<>"",$H6<4)

You cannot return a value via conditional formatting. You can only do that directly in the cell using a conventional formula.

[Potholes]

Good Morning Ali

I have attached my temp file to show how I get around the Conditional formatting.


Regards

Pierre

[AliGW]

What do you mean by "get around the conditional formatting"? Where are we supposed to be looking exactly? Are you in need of help still, or just showboating?

[Potholes]

Hi No Showboating here, Well I hope not,

If you look at cell H6, when you enter 3 in there, and Q6 has a time in there H6 goes red.

Even though I had the Conditional format for H6 I had "ERROR" as part of the formulae, I can see now
why you said it is not possible, I must say here I am sorry for doubting you knowledge, IT WILL NOT HAPPEN AGAIN.

Regards peter

I will mark this as solved.

[AliGW]

My point is this. The formula in F6 has nothing to do with conditional formatting. The conditional formatting rule in H6 is not actually correct, although by fluke it is working. It should be this:

=AND($Q$6>0,$H$6<4)