Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE COLOR OF A ROW
Hi,
How do you make a row change color dependent upon a reponse in one of the cells? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE COLOR OF A ROW
"Dave" wrote:
How do you make a row change color dependent upon a reponse in one of the cells? One way is via conditional formatting .. Let's say you want to color entire rows where the value in col B = 5 Select the entire sheet, apply CF via Formula Is: =$B1=5 (the key is to fix the point to col B using the $ sign) Format to taste ok out Test it out, enter: 5 anywhere in col B, the entire row will get formatted Success? Celebrate it, hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE COLOR OF A ROW
Hi Max
Thanks for that. I didnt realise this coul be done with conditional formatting. Thats great! Thanks "Max" wrote: "Dave" wrote: How do you make a row change color dependent upon a reponse in one of the cells? One way is via conditional formatting .. Let's say you want to color entire rows where the value in col B = 5 Select the entire sheet, apply CF via Formula Is: =$B1=5 (the key is to fix the point to col B using the $ sign) Format to taste ok out Test it out, enter: 5 anywhere in col B, the entire row will get formatted Success? Celebrate it, hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE COLOR OF A ROW
Glad to hear. Could you spare a moment to hit the YES button (like the one
below) in that response? Thanks. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Dave" wrote: Hi Max Thanks for that. I didnt realise this coul be done with conditional formatting. Thats great! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |