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
Can anyone guide me how to do this ??
Student-attendance-record-2-1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for giving your expert suggestion ;-)
You are welcome, I'm glad I could help.
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.