Forum Discussion
Re: Conditional formatting for entire row based on data in one cell
Charlie585 Hi there. I am hoping you can help. I have an Attendance Spread sheet and my cells have a Data Validation list on Columns C4 to CD100, and there are Conditional formats for that. But what I want to do is to have it so that, If we also have one (In any cell from C4 to CD100 that show "Attrition" (Where they leave the company) it will go over to column A and Cross out the name and color the box in Grey. I can do it for 1 column, but format painter or Copy> Paste Special will not copy the formating over. Any tips. Here is a screen shot with fake names. I have tried to change the range to C4:CD4 and C4:CD100, and nothing seems to make a difference. 🙂 Thanks for any help you can give.
11 Replies
I applied that formula....But if I marked Attrition in C56, then all the A cells above are crossed out (A54, A55, & A56 all were crossed off.) I only wanted A56 to be crossed out. Can that be done without wrtting a new format for each column? Thanks so much. I appreciate your help. 🙂
Select A4:A100 or further down if you wish.
A4 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Delete all existing rules.
Click New Rule...'
Select 'Use a formula to determine which cells to format'.
Enter the formula=OR(C4:D4="Attrition")
Click Format...
Activate the Font tab.
Select Italic, and tick the Strikethrough check box.
Activate the Fill tab.
Select a shade of gray as highlight color.
Click OK until all dialogs have closed.
- I also changed it to A4:CD100, and that didn't make a difference. I have tried with $ before the column and rows. Nothing seems to give me what I am hoping for. I appreciate the help. 🙂
