• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 82
  • Last Modified:

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
0
Aamir Hussain
Asked:
Aamir Hussain
  • 3
1 Solution
 
RaminTechnical AdvisorCommented:
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.

1.jpg
0
 
RaminTechnical AdvisorCommented:
You can do the same for any cell that you want.

just Select those Cells and follow above procedure.

2.png
Please feel free if you have more questions.
1
 
Aamir HussainAuthor Commented:
Thanks for giving your expert suggestion ;-)
1
 
RaminTechnical AdvisorCommented:
You are welcome, I'm glad I could help.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now