Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I was to set a particular color to a row based on some condition. ForEx: if the value of a cell E5 is 'closed', then set that entire row to 'grey' color. How do I do that? |
#2
![]() |
|||
|
|||
![]()
Use conditional formatting.
Select all the rows (let's assume it is E-M in this case). Go to CF. Change Condition 1 to Formula Is Add a formula of =$E5="closed" Click Format button and format as desired OK out -- HTH RP (remove nothere from the email address if mailing direct) "Venkatesh V" wrote in message ... Hi, I was to set a particular color to a row based on some condition. ForEx: if the value of a cell E5 is 'closed', then set that entire row to 'grey' color. How do I do that? |
#3
![]() |
|||
|
|||
![]()
HI,
The below solutionh was enouigh to set for a single row. I selected some 5 rows and try to "Paste Special" with only the FOrmats of that row. It didnt work. "Bob Phillips" wrote: Use conditional formatting. Select all the rows (let's assume it is E-M in this case). Go to CF. Change Condition 1 to Formula Is Add a formula of =$E5="closed" Click Format button and format as desired OK out -- HTH RP (remove nothere from the email address if mailing direct) "Venkatesh V" wrote in message ... Hi, I was to set a particular color to a row based on some condition. ForEx: if the value of a cell E5 is 'closed', then set that entire row to 'grey' color. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |