Excel Cells Color ?

Is ther a way to have a range of cells have a given color based on the content of a cell?
Say cell A2 = 'Paid' then I want cells A2 through D2 to be blue otherwise regular color.
LVL 1
Jess31Asked:
Who is Participating?
 
nutschCommented:
Screencast is cut too high. Let me redo it:
nutsch-440832.flv
0
 
nutschCommented:
Use conditional formatting, as shown in the attached screencast

nutsch-440829.flv
0
 
Lordy123Commented:
0
 
jppintoCommented:
Please just check the attached example and image to see how to do this in your case.

jppinto
Conditional-formatting2.xls
Capture.JPG
0
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.

All Courses

From novice to tech pro — start learning today.