Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
58
Views
Topic starter
That's the part of my report. I want to autofill them with red colour if the grades are lower than 5 and with green colour if the grades are higher than 5. What formula should I put in C2-C5 cells?
Posted : 19/09/2021 2:50 am
Please add a worksheet rahter than a picture otherwise we have to waste time recrating data that already exists
Do you want 5 to not have a colour? What cells do you want coloured in?
A simple Conditional format with =b2>5 green will make them green and =b2<5 will make red
Posted : 19/09/2021 2:08 pm
Topic starter
OK, thank you, I got your idea
Posted : 21/09/2021 9:31 am