Function to change color to group of cells..

**kenharding** · 09-15-2014, 11:29 AM

I can't get the proper format for this.

If D5 is Yes
Then C5:C20 cells will be red

If D5 is No
Then C5:C20 will not change.

Thats All .. Thanks

**Special-K** · 09-15-2014, 11:36 AM

Select C5

Conditional Formatting
New Rule
Use a formula to determine...

=(D$5="Yes")
format as red

Use Format painter (paintbrush icon) to copy to other cells

**kenharding** · 09-15-2014, 12:35 PM

Thanks for the help.

I was trying to write it out. Forgot string $

Function to change color to group of cells..

LinkBack

Thread Tools

Rate This Thread

Display

Function to change color to group of cells..

Re: Function to change color to group of cells..

Re: Function to change color to group of cells..

Thread Information

Users Browsing this Thread

Similar Threads

New to add color the blank row being added after group change.

[SOLVED] change fill color of a range of cells based on color of a cell?

[SOLVED] Change color of text for a group of shapes

Automatically change fill color on certain cells depending on color of specific cell

[SOLVED] Change cell color if it is the lowest number of a group?

Bookmarks

Bookmarks

Posting Permissions