Formula help for flag

Occasional Contributor

Hi Experts, 

 

I want to add Flag Green if value is 0 in B3, and red flag when value in B4.

Kindly suggest.

 

rahul_oberoi_1-1634727966213.png

 

3 Replies

@rahul_oberoi 

You can enter one rule for green and the other rule for red conditional formatting:

=IF(COUNT(FIND("Completed",D7:G7))=4,1,0)

=NOT(IF(COUNT(FIND("Completed",D3:G3))=4,1,0))

In my example both rules apply to range B3:B7.

Thanks for your kind help , Is there any way we can add Flag icon instead of color.

@rahul_oberoi 

Sorry i missed that you want to flag cells.

Go to conditional formatting, icon sets and indicators and choose the flags.

When you did this you can adjust the formatting rule according to your requirement if this is necessary.