Link to home
Start Free TrialLog in
Avatar of Aamir Hussain
Aamir Hussain

asked on

How to change color of excel code based condition cell

I found a attendance result sheet where i can add daily wise attendance of each student. If i enter "A" student is considering as absent. Absent student cell is showing as RED. I want to change color of this cell ??

Can anyone guide me how to do this ??
Student-attendance-record-2-1.xlsx
Avatar of Ramin
Ramin

Go to student Attendance page.
select all cells from  C14 to AG37
Select Home tab.
Select Conditional formatting.
Select Manage Rules.
Click on second Item ( red one, I changed it to Yellow in this screenshot)
Select Edit Roles.
Click on format.
Select Fill tab.
Select your desire color.
select OK.

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Ramin
Ramin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aamir Hussain

ASKER

Thanks for giving your expert suggestion ;-)
You are welcome, I'm glad I could help.