View Full Version : Message in cell when criteria is met
Masti
08-16-2018, 12:43 AM
Hello guys,
i don't have much knowledge in excel and i can see here are guys who are really good at it, so i'm hoping you can help me. I need VBA to look at cell B3 and when there is number more than 120, cell C3 colors red and message "Criteria is met" appears.
Thanks in advance
p45cal
08-16-2018, 02:32 AM
In the attached is conditional formatting in cell C3 (not VBA).
That cell contains the message, but it's in white, so not visible.
The conditional format formula is:
=$B$3>120
and the conditional formatting is to colour the cell red and the font colour Automatic, where upon the message becomes visible in a red cell.
Masti
08-16-2018, 03:58 AM
In the attached is conditional formatting in cell C3 (not VBA).
That cell contains the message, but it's in white, so not visible.
The conditional format formula is:
=$B$3>120
and the conditional formatting is to colour the cell red and the font colour Automatic, where upon the message becomes visible in a red cell.
Thank you, that's what i was looking for! :bow::joy:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.