Forum

Notifications
Clear all

What Formula Should I Select

3 Posts
2 Users
0 Reactions
108 Views
(@bonanza-bonanza)
Posts: 6
Active Member
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
(@purfleet)
Posts: 412
Reputable Member
 

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
(@bonanza-bonanza)
Posts: 6
Active Member
Topic starter
 

OK, thank you, I got your idea

 
Posted : 21/09/2021 9:31 am
Share: