Make a cell go red and say "Check Glass"

[swfarm]

Hi Guys

I really have no idea how to make this work even though ive read about conditional formatting so your help really would be appreciated

in cells B16 i have a width in metres
in cell B17 i have a height in metres

I need cell B28 to flag up red and say "Check glass" if the following happens

if B16 * B17 is more than 2.5 OR/AND if B16 and B17 are both bigger than 1.399

I really would appreciate any help regarding this

[shukla.ankur281190]

Try in conditional formatting =OR(B16*B17>2.5,AND(B16>1.399,B17>1.399))

[leelnich]

Try in conditional formatting =OR(B16*B17>2.5,AND(B16>1.399,B17>1.399))

...And paste this in B28:

Please Login or Register  to view this content.

[alansidman]

This can be done with VBA

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[shukla.ankur281190]

...And paste this in B28:

Please Login or Register  to view this content.

oh! I did miss it thank you

[swfarm]

hi guys

the formula works well but it doesnt make the cell red what am i doing wrong please?

ive put it into conditional formatting > new rule > use a formula > pasted formula in and changed to red clicked ok but it doesnt turn cell red when the criteria is met only says check glass

[AliGW]

Check that you have the correct cell or cell range in the Applies To box in the CF dialog.

[swfarm]

sure do
it just doesnt change the colour
its just like a normal cell would be

[shukla.ankur281190]

Row\Col	A	B	C	D
16		3.5
17		1
18
19
20
21
22
23
24
25
26
27
28		TRUE	Check Glass

Check the attached file here it is working great

[leelnich]

It worked fine for me.
Untitled.png

[swfarm]

sorry guys

my mistake i was typing =IF(OR(B16*B17>2.5,AND(B16>1.399,B17>=B16)),"Check Glass","") into the conditional formatting

sorted now
thank you so so much

[leelnich]

You're welcome, and thank you for the rep!