Conditional Formatting using VBA

Fenix187

New Member
Joined
Mar 20, 2017
Messages
17
Hi all and hope everyone is well.

So here is my request or call to help.

I am looking to use conditional formatting.

Students already have grades attached to them, however I require the condition formatting to kick in when the adjusted grade is input.

Grades which are matching should be ignored. Adjusted grade fields which are empty should be ignored.

Adjusted grades which below current target should be highlighted in RED.

Adjusted grades which above current target should be highlighted in Light Blue.

I've attached a Excel doc which demonstrates my ideal outcome.

Thank in advance to everyone that can help.

Also asked here Conditional Formatting using VBA
 

Attachments

  • Test4.PNG
    Test4.PNG
    9.9 KB · Views: 5
Last edited by a moderator:

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,133,244
Messages
5,657,582
Members
418,401
Latest member
B_A_M155

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top