i need to change row colour based on text.
eg.
if B1 has "entered" then turn B1 through to BD1 green.
I can only work out how to change cell not row.
i need to change row colour based on text.
eg.
if B1 has "entered" then turn B1 through to BD1 green.
I can only work out how to change cell not row.
Select the whole range B1:BD1 and use this formula in conditional formatting
=$B1="Entered"
Note the $
Audere est facere
where do i put this?
i click conditional formatting then which option do i choose?
In Excel 2007 select "New Rule", then "Use a formula to determine which cells to format" and then paste or type that formula in the box, then select required formatting.
Make sure that the formatting applies to the whole range. If you select the range first then it will by default......
Thank you thats great ....
one more thing how would i write the same but instead of "entered" it would highlight row if there is anything starting with "CR"?
You can use LEFT function for that, i.e.
=LEFT($B1,2)="CR"
That's not case-sensitive, if you want it to be then there are other approaches......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks