Conditional format based on other conditional formats?

**TPDave** · 10-23-2014, 10:14 AM

Hi All,

I have a sheet that has a bunch of conditionally formatted cells in a row and want to have one cell at the end that goes green if all the preceding cells are a certain format and red if not. Is there a way of doing this without making some kind of convoluted format that just lists all of the requirements for the individual cells before it?

I have attached an example sheet, I would like G12:G21, U12:U21 and Y12:Y21 to be green if the cells in the block to their left are all green and red if not.

Thanks

**Fotis1991** · 10-23-2014, 11:11 AM

Hi

A little ugly but works

!

Look in column g(i manually highlighted the cells with a grey color, just to see the difference easily)

Formula:

Please Login or Register  to view this content.

**FDibbins** · 10-23-2014, 11:22 AM

try this, using New Rule, Use formula

Highlight G12:G21
go into CF
New Rule/Use Formula
=AND(COUNT(C12:F12)>0,SUM(C12:F12)>$R$2*COUNT(C10:F10)-SUMPRODUCT(C10:F10*365)).........format fill GREEN

If you use regular formatting and color all the cells red, you will only need 1 rule here

**TPDave** · 10-23-2014, 11:23 AM

Thank you, yeah it'll be a slog to update if more columns get added or whatever, but it works!

Thanks

**FDibbins** · 10-23-2014, 01:48 PM

If you add a column and hide it after F, you could include that in my formula, then when you add more columns, add them before the hidden column, and the formula will adjust itself

Thanks for the feedback, too

Conditional format based on other conditional formats?

LinkBack

Thread Tools

Rate This Thread

Display

Conditional format based on other conditional formats?

Re: Conditional format based on other conditional formats?

Re: Conditional format based on other conditional formats?

Re: Conditional format based on other conditional formats?

Re: Conditional format based on other conditional formats?

Thread Information

Users Browsing this Thread

Similar Threads

Custom Number Format can only display 3 Conditional formats using the [ ] parameters

Excel 2007 : Conditional Format based on another worksheet conditional format

Conditional Format with more than 3 formats, and different criteria per column

conditional format wont run 2 formats at once

Change formats based on A:A cell value on each row - (not with conditional format!) ?

Bookmarks

Bookmarks

Posting Permissions