I have a column that will have only 'Have Access' or 'No Access'
if it's 'Have Access' i would like to have a background color when exporting to excel.
The formula would be something like
if {Clinician_.Access} = 'Has Access' then yellow else white. Is it a formula for each row or done on Format?