Conditional formatting with multiple conditions

[Falak]

I want to apply conditional formatting on specific cells/records with multiple conditions.
Font colour of the products rates offered by suppliers should become white (invisible) if cell $F$3 value is set to/selected as '= Lowest Only' without effecting highlighted (lowest rate) cells (conditional) formatting, like the table starting at L4. sample data is attached in Excel 2016. however, reply may be given in Excel 2021 version.

 

[ETAF]

try a new rule in conditional formatting

=C5<>$H5

BUT i was not sure what the drop you wanted - as does not match

so that would mean modifying with an AND

AND( $E$3="Lowest Only" , C5<>$H5)

BUT not an Lowest only ???
SHOW LOWEST - is that want you want
HIGHLIGHT LOWEST - or is it this

so
which ever one you want
AND( $E$3="Show Lowest" , C5<>$H5)
AND( $E$3="Highlight Lowest" , C5<>$H5)

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
C5:G16 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=C5<>$H5

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK