conditional formula for the cell in excel

Question

0.00/5 (No votes)

See more:

Hai,

I have a excel sheet which contains few columns.

Event Date     Holder	        Name            Validation
10/30/2013    Entry Granted  YUVARAJ             FALSE
10/30/2013    Exit granted   YUVARAJ             FALSE

I have put the above columns in the excel file in the cell A and B.

Suppose if the next row is empty row (ie) Cth row then how can i display the validation set to "true".Plz help me.

Thanks in advance.

Posted 25-Nov-13 3:11am

Member 10234093

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2013-11-25T04:11:00

Solution 1

Something like:

=IF(ISBLANK(A2), "TRUE","")

Using the Excel help menu item will find you lots of useful information.

Permalink

Posted 25-Nov-13 4:11am

Richard MacCutchan

Updated 25-Nov-13 4:12am

v2

CHill60 · Answer 2 · 2013-11-25T04:18:00

The function you are looking for is ISBLANK

For example in cell D4 have a cell formula =ISBLANK(C4), D5 has =ISBLANK(C5) etc etc

Personally I would have had the validation set to TRUE if the data WAS entered in which case I would have used the formula =NOT(ISBLANK(C4))

It is very easy to get tied up with multiple isblank functions especially with localisation, dates, other formulas etc etc ... this set of search results mentions several google search for isblank issues[^] but I wouldn't worry about them unless/until you hit them

Finally, be careful about your terminology (so that it is easier for more people to help you out)

Member 10234093 said:
I have put the above columns in the excel file in the cell A and B.

. You actually meant that you have put the above data in rows 2 and 3 where row 1 is the headings row.

So ...
rows have numbers - usually these are displayed down the left hand side
columns have letters - usually displayed across the top of the sheet
cells are identified by their column + row e.g. C4 above.

conditional formula for the cell in excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

conditional formula for the cell in excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us