Obviously I can very easily apply a conditional format to a cell based upon the value returned in that cell, but can this easily be expanded to conditionally format all the cells in the row and not just the cell that is being queried? Basically I am running a report and one of the columns records 'service impact'. If this is set to 'loss of service' I want to shade not only the cell in question red, but the whole of that row.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I conditional format a whole row in Excel 1
- Thread starter beanxx
- Start date
-
1
- #2
This is very easy for you.
All you have to do is select the entire report, do menu command Format/Conditional Formatting, and choose a condition type of "Formula Is" from the dropdown, and then enter this equation is the next box ...
=$C1="loss of service"
assuming that column C is the column for 'service impact' and that the first row of the selection to be formatted is row 1. Press the Format button, choose a Pattern of whatever shade of red you want, press OK, press OK.
That should do what you want.
Glenn.
All you have to do is select the entire report, do menu command Format/Conditional Formatting, and choose a condition type of "Formula Is" from the dropdown, and then enter this equation is the next box ...
=$C1="loss of service"
assuming that column C is the column for 'service impact' and that the first row of the selection to be formatted is row 1. Press the Format button, choose a Pattern of whatever shade of red you want, press OK, press OK.
That should do what you want.
Glenn.
- Thread starter
- #3
is their a quick way to apply the condition to all rows?If you select the ENTIRE report, and the active cell of the selection is row 1, then the condition formatting will work for the entire report as it is. You do not need to redo this for every row. The formula uses $C1 for the reference, i.e. the column ref is fixed for all cells of the report, but the row ref is relative, i.e. the formatting will apply to each row depending on the contents of that row.
Glenn.
Glenn.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question