Getting Specific cell value in an If condition

Help Studio
, ,
1

Hello,
Am trying to check if specific cell content is a yes or No so that I can format the excel if its a YES, but am unsure how to check for a yes or no
Here is a sample of the excel

image
image999×183 4.76 KB

The cell that am supposed to check is F2 if its either YES or NO
How do I go about it?

2

I would really appreciate your help

3

Hi @pattwagunyi ,

Have you tried using Read Cell Activity ? You can get the data from that particular cell using this activity and then you should be able to perform comparison with it.

4

Let try that one one
What if the cell is dynamic ie the location of NO/YES keeps changing?

5

@pattwagunyi ,

In that case, we would need to know how would a human/user understand that it is in that particular location, we could mimic the same logic and achieve the result, we need to have a condition and then extract the value.

Let us know what is the condition that we could apply here.

6

This has worked, thank you!!

1 Like
7

The files are being edited by different people, but I guess for now the format is the same so the cell is static

1 Like
8

Hi @pattwagunyi is your cell address(F2) for value YES/NO is constant?

9

For now, yess its constant

10

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