Oct 20 2021 04:08 AM - edited Oct 20 2021 06:11 AM
Hi Experts,
I want to add Flag Green if value is 0 in B3, and red flag when value in B4.
Kindly suggest.
Oct 20 2021 06:11 AM
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.
Oct 20 2021 06:13 AM
Oct 20 2021 06:34 AM
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.