Conditional Formatting Help

J

Justinian

Well-known Member
Joined
Aug 9, 2009
Messages
1,557
Office Version
  1. 365
Platform
  1. Windows
When I run CF, it only highlights the cell that contains my words. How do I get Excel to highlight the entire row?
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Sort by date Sort by votes
What column is the value "reviewed" found in? Also what is the range of the whole table? For example, A2:F90.
 
Upvote 0
Column B contains the "reveiwed" text. The table is A2:F30.
 
Upvote 0
Try highlighting all of the table starting from A2, and use the "Use a formula to determine which cells to format" option. Then in the formula bar use this formula:

=$B2="reviewed"

(untested but should work)

Edit: I should note that your "reveiwed" appears to be spelled wrong. Assuming that's a typo here, there shouldn't be any problem, but if it's spelled that way on your worksheet you will need to change the spelling, or change the formula.
 
Last edited:
Upvote 0
That only highlights the cell containing the work reviewed. it does not highlight the row.
 
Upvote 0
Did you highlight the whole table before entering the formula? Also, make sure to clear any prior rules.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Conditional Formatting in Excel Table and Ignore Blanks Not Working
Replies
3
Views
250
Joe4
Joe4
M
  • Solved
Conditional Formatting behavior question
Replies
6
Views
276
Mr_Phil
M
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
233
etaf
etaf
SaraWitch
  • Solved
Highlight row if cell contains text but not if date is entered (but generally formatted!)
Replies
7
Views
81
etaf
etaf
I
  • Question
Conditional formatting with multiple conditions
Replies
3
Views
157
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,636
Messages
6,120,669
Members
448,977
Latest member
moonlight6

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top