Color Conditional Formatting
I would like a conditional formatting in
column A would be RED if the range from B to D has a color RED. column A would be YELLOW if the range from B to D is YELLOW OR GREEN column A would be GREEN if the range from B to D is all green A B C D RED YEllow Green Red YELLOw Green YELLOW GREEN GREEN GREEN GREEN GREEN Thanks! |
Color Conditional Formatting
A1
=IF(COUNTIF($B1:$D1,"Red")0,"Red",IF(COUNTIF($B1: $D1,"Green")=3,"Green","Yellow")) Copy down from A1 to A3 Condition Formatting condition 1: =A1="Red" (format as red) condition 2: =A1="Yellow" (fromat as yellow) condition 3: =A1="Green" (format as green) "Conditional Formatting" wrote: I would like a conditional formatting in column A would be RED if the range from B to D has a color RED. column A would be YELLOW if the range from B to D is YELLOW OR GREEN column A would be GREEN if the range from B to D is all green A B C D RED YEllow Green Red YELLOw Green YELLOW GREEN GREEN GREEN GREEN GREEN Thanks! |
All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com