IF statement with nested Cell color change question

Help Studio
1

Is it possible to use a write cell with a IF statement to change the color of a cell?

if greater then zero Red Else Green.

![The image shows an Excel sheet displaying a table of unposted payments needing accruals by directorate and division, with conditional formatting applied to the “Total” column to color code values based on being greater than 0, and an inserted text box explaining the condition.

The image shows an Excel spreadsheet for managing unposted payments in need of accruals categorized by directorate and division, along with instructions and a script for conditional formatting and cell writing automation. (Captioned by AI)
The image shows an Excel spreadsheet for managing unposted payments in need of accruals categorized by directorate and division, along with instructions and a script for conditional formatting and cell writing automation. (Captioned by AI)863×743 41.9 KB

2

@Waterfowl_Waterfowl_hunte,

You will have to use Format Cells activity in if else condition.

Thanks,
Ashok :slightly_smiling_face:

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.