Forum Discussion
Solved
Excel - Conditional formatting - how to duplicate AND change the 'Rule Cell Value'
Hi, I'm am creating a quality assurance process for my business. For example, I need to test an oven every 6 months. I want to make sure that the oven heats to 180C every time we test it. If the ...
Refer to the following screenshot to create a New Rule for conditional formatting...
All you need to do is...
Select the range B2:Cn where n is the last row and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
=B2<>C2Refer to the following screenshot to create a New Rule for conditional formatting...
THANK YOU! It works. Something so simple. Subodh_Tiwari_sktneer
- You're welcome Carla2404! Glad it worked as desired.
